ETL Developer/ Allen Park, MI (Onsite), 12 Months Contract

Job Description 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. Job Description • 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.