Informatica Developer - California, United States - Hyring

Description

Key skills: Informatica PowerCenter, MS SQL

Experience level – Senior/Lead (5+ Years)

Seeking for candidates in: USA

Work Type: Full-time from USA

Work Mode: Remote

Requirement:

• Experience in developing ETL mappings using Informatica Designer
• Strong understanding on ETL and Data Engineering Concepts and ability to learn new ETL tools on the Job.
• Proficient in Informatica Cloud, Informatica Power Center
• Strong proficiency in ETL/ELT development and cloud-based data services (e.g., AWS, Azure, GCP environments).
• Configuring and sessions/workflows using Workflow Manager
• Good Understanding on the Complete Project life cycle, business' process and workflow Understanding of / exposure to Reporting a plus.
• Knowledge in DBT and MDM an added advantage
• Mentoring / Training the team in all aspects of knowledge needed for the project.

Additional requirement:

• Proficient in basic and advanced SQL programming concepts (Procedures, Analytical functions etc.)
• Good Knowledge and Understanding of Data warehouse concepts (Dimensional Modeling, change data capture, slowly changing dimensions etc.)
• Knowledgeable in Shell / PowerShell scripting
• Knowledgeable in relational databases, nonrelational databases, data streams, and file stores
• Knowledgeable in performance tuning and optimization
• Experience in Data Profiling and Data validation
• Experience in requirements gathering and documentation processes and performing unit testing.
• Understanding and Implementing QA and various testing process in the project
• Knowledge in any BI tools will be an added advantage Sound aptitude, outstanding logical reasoning, and analytical skills.
• Willingness to learn and take initiatives.
• Ability to adapt to fast-paced Agile environment.