Azure Data Factory ADF - Data Engineer

CGS Business Solutions is committed to helping you, as an esteemed IT Professional, find the next right step in your career. We match professionals like you to rewarding consulting or direct hire opportunities in your area of expertise. We are currently seeking Technical Professionals who are searching for challenging and rewarding jobs for the following opportunity:CGS is currently accepting resumes for a Sr. Data Engineer for a full-time position in Los Angeles. This hybrid remote & in the office role will be utilizing Azure Data Factory, Power BI, Oracle, Snowflake, Informatica IICS. Job Duties:Participate in design, implementation, and support of a data warehouse and analytics platformDesign and develop robust ETL / ELT processes, primarily using tools like Azure Data Factory (ADF) and Informatica Cloud (IICS).Perform proof of concepts for innovation and to continuously improve and enhance the capabilities of the data analytics platform.Train and educate internal team members as well as partner consultants about best practices in data engineering and governance.Skillset:Datawarehouse Design Skills: Focus area includes exceptional skills with data design and managementStrong Experience with data warehousing ETL process design/development/support (Azure Data Factory, Informatica, ODI).ETL Process Skills : Strong Knowledge of ETL Processes and SQL Query expertise.Proven experience working with REST APIs and bringing data from REST APIs from multiple sources.Extensive experience in SQL/PLSQL, Logical SQL Queries and Performance TuningExcellent understanding of star/snow-flake schema, SCDs and de-normalized operationsDesign, model, document, and guide the logical and conceptual relationship of data and database changes for BI applications.Experience in leading requirements gathering, gap analysis and create user requirements documentation.Experience with Microsoft Analytics stack and solid exposure to varied databases such as Snowflake, RedShift, Oracle DW etc.Experience working with ERP systems data such as Oracle EBS/Fusion (Purchasing, Order Management, Manufacturing and/or Financials modules).Experience working with agile methodologies using CI/CD techniques in a DevOps environment using Azure DevOps and Git.Experience with machine learning (Python, R, Azure ML, etc.) is a plus. About CGS Business Solutions:CGS specializes in IT business solutions, staffing and consulting services. With a strong focus in IT Applications, Network Infrastructure, Information Security, and Engineering. CGS is honored to be selected as one of the Best IT Recruitment Firms in California. After four consecutive Fastest Growing Company titles, CGS continues to break into new markets across the USA. Companies are counting on CGS to attract and help retain these resource pools in order to gain a competitive advantage the rapidly changing business environments. - provided by Dice

Created: 2025-11-15