Job description
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.
