ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
Specialization
ETL Specialization: Data Engineer
Job requirements
• ETL: SSIS, Denodo • Databases: SQL Server, Oracle • Scheduler: Control-M Job Description – Data Engineer (A1 Band: 3–5 Years) Job Title: Data Engineer Experience Band: A1 (3–5 Years) Job Purpose As a Data Engineer, you will contribute to the design, development, and support of enterprise data platforms. You will work with senior engineers to implement efficient ETL processes using SSIS, Denodo, SQL Server, and Oracle, while leveraging Control-M for job scheduling. This role is an excellent opportunity to strengthen your expertise in SQL development, data integration, and performance optimization within a large-scale enterprise environment. Role & Responsibilities: • Develop, test, and maintain SQL queries, stored procedures, and views to extract and transform data from multiple sources. • Implement ETL workflows using SSIS and Denodo for data integration. • Schedule and monitor jobs using Control-M to ensure timely data processing. • Perform data profiling, source-to-target mapping, and data validation activities. • Optimize SQL queries and troubleshoot performance issues. • Support database operations on SQL Server and Oracle. • Participate in unit testing and assist with data quality checks. Candidate Profile: • Bachelor’s degree in Computer Science, Information Technology, or related field. • 3-5 years of experience as a Data Engineer or in a similar role. • Strong knowledge of SQL (T-SQL/PL-SQL) and relational databases. • Hands-on experience with SSIS and basic Denodo knowledge. • Exposure to Control-M job scheduling. • Strong problem-solving and analytical skills.
