Senior Engineer

Company Description

We are a Digital Product Engineering company that is scaling in a big way! We build products, services, and experiences that inspire, excite, and delight. We work at scale — across all devices and digital mediums, and our people exist everywhere in the world (18000+ experts across 36 countries, to be exact). Our work culture is dynamic and non-hierarchical. We are looking for great new colleagues. That is where you come in!

Job Description

Must have Skills : Informatica PowerCenter

Good To Have Skills :

Job Description :

• 2+ Yrs. Of experience relevant to developing and managing ETL on Informatica Power Center (version 10.5 and above)
• 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.
• Must be able to use Informatica Data Quality tools.
• Must have experience in Informatica Admin Center.
• 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).
• Should have knowledge on Snowflake, Java Transformation - Proficiency in SQL and experience with relational databases (Oracle, SQL Server) with Strong SQL skills for data extraction, transformation, and loading.
• Strong understanding of SQL Stored Procedures, Functions, Cursors, DDL, DML.
• Should have experience with data warehousing concepts and techniques.