ETL DEVELOPER

Job summary:

• 5/6+ years of experience in ETL with at least 3+ years in Informatica.
• Strong experience in designing and developing ETL mappings, mapplets, workflows, sessions using Informatica PowerCenter.
• Experience in Informatica Power Center 9.x (ETL) – (Designer, Repository Manager, Workflow Manager), Job Schedulers.
• Good experience in Informatica cloud (IICS) with Data integration and application integration.
• Experience in informatica Data quality with profile , score card creation and mapping with different data quality transformations and Experience with Informatica analyst tool.
• Must have experience in building complex SQL queries.
• Strong on DW Fundamentals, concepts.
• Understands and review technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems.
• Excellent understanding of various relational database design concepts.
• Extensive experience in Data Modelling & Architecture.
• Experience full lifecycle data warehouse development.
• Experience in managing BI App Support.
• Error handling and Performance Improvements.
• Conduct and participate in design and code walkthroughs.
• Good hands-on capability – can independently develop good quality deliverable and guide/mentor junior team members effectively.
• Participate in requirements gathering sessions with stakeholders from business and IT teams.
• Communicates effectively with business partners to identify needs and evaluate options.
• Help BI reporting developers with analysing data source, designing, testing, and implementing Analytics reports and dashboards.
• Ready to work in shifts.