We are looking for an experienced and motivated Data Engineer to join our dynamic team. In this role, you will participate in the delivery of key projects in support of North America Data Delivery team with focus on MDM projects.  You will be responsible for leading ETL development projects, coordinating with cross-functional teams to ensure project success, and creating and maintaining data integration solutions to meet business requirements. The ideal candidate will have experience with ETL development solutions such as Informatics MDM, Azure Data Factory, Snowflake, Informatica/IICS and be able to identify and resolve data quality issues, performance bottlenecks, and other ETL-related problems.

In this role, you will:

Manage ETL development projects and coordinate with cross-functional teams to ensure project success Create and maintain data integration solutions to meet business requirements Identify and resolve data quality issues, performance bottlenecks, and other ETL-related problems Design and develop scalable ETL workflows and data pipelines using ETL tools such as Informatica/IICS Ensure compliance with data governance and security policies Develop and maintain documentation such as technical design documents, data lineage, and ETL runbooks Evaluate modern technologies and tools, and recommend solutions to improve ETL processes and performance Contribute to the architecture, design, and development of data warehousing and business intelligence solutions Understands data mapping and data modeling methodologies including normal form, star, and snowflake to reduce data redundancy and improve data integrity. Participate in analysis, design, and ETL development as part of Agile development methodologies and provide status updates to the management Maintains knowledge on current and emerging developments/trends for assigned area(s) of responsibility, assesses the impact, and collaborates with Scrum Team and Leadership to incorporate current trends and developments in current and future solutions

 

Bachelor’s degree or equivalent work experience (4 years of experience in lieu of Bachelors) At least 5+ years of Strong understanding of ETL development concepts and tools such as ETL development solutions (e.g., Informatica MDM, Azure Data Factory, Snowflake, Informatica/IICS)  Experience with Data Warehousing and Business Intelligence concepts and technologies Strong knowledge of SQL and advanced programming languages such as Python and Java Demonstrated critical thinking skills and the ability to identify and resolve data quality issues, performance bottlenecks, and other ETL-related problems Experience with Agile methodologies and project-management skills Excellent communication and interpersonal skills Ability to mentor and provide technical guidance to junior ETL developers Experience with cloud based environment required. 2+ years of experience in scheduling jobs using Autosys (or comparable distributed scheduler) 3+ years of experience writing Unix/Linux or Windows Scripts in tools such as PERL, Shell script, Python, etc. 3+ years of experience in creating complex technical specifications from business requirements/specifications