Technical Experience: -
· Required 6 to 10 years of experience in Informatica development.
· Hands-on experience in design and implementation of Data Warehousing solutions
· Develop and Test ETL Mappings, Mapplets, Workflows using Informatica 10.x & above.
· Strong knowledge on Oracle SQL and Performance tuning.
· Able to participate in requirement gathering by engaging SME’s & Technical team.
· Work with stakeholders to understand business requirements, translate them into technical solutions, and recommend best practices
· Understands data integration processes
· Can develop work plans and follow through on assignments with minimal guidance
· Identifying solutions to key technical challenges in projects concerning data warehousing and business intelligence
· Must have hands-on experience of relational and dimensional modeling
· Data Modeling Expertise Conceptual, Logical, Physical in both Relational & Dimensional
· Must have experience in understanding business vision to prepare ETL solution architecture
· Well experienced in designing ETL/ELT approaches while authoring the data flows
· Attitude towards problem solving, analytical and interpersonal skills.
· Hands on experience in dealing with Oracle ERP data source is a plus
· Excellent communication skills, with the ability to explain technical concepts to non-technical stakeholders.
· Strong analytical skills and attention to detail.
Technical Experience: -
· Required 6 to 10 years of experience in Informatica development.
· Hands-on experience in design and implementation of Data Warehousing solutions
· Develop and Test ETL Mappings, Mapplets, Workflows using Informatica 10.x & above.
· Strong knowledge on Oracle SQL and Performance tuning.
· Able to participate in requirement gathering by engaging SME’s & Technical team.
· Work with stakeholders to understand business requirements, translate them into technical solutions, and recommend best practices
· Understands data integration processes
· Can develop work plans and follow through on assignments with minimal guidance
· Identifying solutions to key technical challenges in projects concerning data warehousing and business intelligence
· Must have hands-on experience of relational and dimensional modeling
· Data Modeling Expertise Conceptual, Logical, Physical in both Relational & Dimensional
· Must have experience in understanding business vision to prepare ETL solution architecture
· Well experienced in designing ETL/ELT approaches while authoring the data flows
· Attitude towards problem solving, analytical and interpersonal skills.
· Hands on experience in dealing with Oracle ERP data source is a plus
· Excellent communication skills, with the ability to explain technical concepts to non-technical stakeholders.
· Strong analytical skills and attention to detail.