Associate Staff Engineer

Summary

Join our dynamic and global Digital Product Engineering company as an ETL Developer! We are scaling rapidly and seeking talented individuals to contribute to our innovative projects. This role requires 4+ years of experience in developing and managing ETL processes using Informatica PowerCenter (version 10.5 and above). You will design, develop, and implement complex mappings and workflows, optimize ETL processes for efficiency, and perform data analysis to ensure data quality. Proficiency in SQL and experience with relational databases are essential. This position offers a chance to work with a diverse team on challenging and rewarding projects.

Requirements

• 4+ Yrs. Of experience relevant to developing and managing ETL on Informatica Power Center (version 10.5 and above)
• Must be able to use Informatica Data Quality tools
• Must have experience in Informatica Admin Center
• Should have knowledge on Snowflake, Java Transformation
• Strong understanding of SQL Stored Procedures, Functions, Cursors, DDL, DML
• Should have experience with data warehousing concepts and techniques

Responsibilities

• Design, develop, and implement complex mappings, sessions, and workflows using ETL processes using Informatica PowerCenter
• Identify the problems and Optimize ETL processes for maximum efficiency and performance through performance tuning
• Perform data analysis and data profiling to ensure data quality and integrity
• Develop and maintain reusable data mappings, workflows, and sessions, (Mapplets, Worklets)
• Must have ability to work on different source and target data stores (XML, MSSQL, Oracle, CSV)
• Proficiency in SQL and experience with relational databases (Oracle, SQL Server) with Strong SQL skills for data extraction, transformation, and loading

Preferred Qualifications

Informatica PowerCenter