ETL Developer/Allen Park, MI; Onsite
Listed on 2026-07-01
-
IT/Tech
Data Engineering, Data Warehousing
ETL Developer
Design, develop, and maintain Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimization.
Analyzes the impact of changes on existing ETL processes and systems. Assesses the compatibility with goals in all areas.
Debug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, and exception data processing, troubleshoot and recommend improvements and alternate methodologies.
Design, develop, and maintain Snowflake database objects (tables, views, stored procedures, etc.) and SQL scripts.
Participate in code reviews and ensure that all solutions are aligned with pre-defined architectural and requirement specifications.
Analyzes and resolves problems and provides technical assistance as necessary. Implements corrective actions.
May prepare or review product documentation, written instructions, or technical literature for accuracy and completeness.
Maintenance of business rules associated with data integration.
Participate in the fulfillment of ad-hoc data requests from internal business owners.
Participate in design reviews and provide input to the design recommendations; provide input to information/data flow, understand and comply with Project Life Cycle Methodology in all planning steps.
Experience
Required:
- 5+ years of ETL development experience preferably in Informatica Intelligent Cloud Service (IICS) and SQL Server Integration Services (SSIS).
- 5+ years of experience working with basic Linux Server Operations like managing IDs, access, SFTP file transfer operations etc.
- 5+ years of experience in SQL Server or any relevant database.
- 3+ years of team lead experience.
- Experience in designing/implementing APIs/Microservices.
- Experience of working under PDO model.
- Familiarity with Agile work practices (backlog, scrum ceremonies etc.) and associated tools (Rally etc).
- Ability to quickly adapt to changes.
- Strong analytical and critical decision-making skills.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).