Job Description :
At least 5+ years of experience in developing ETL solutions using Informatica PowerCenter.
Should have strong experience of working in Vertica and ParAccel Database.
Experienced in designing and developing Informatica PowerCenter ETLs for Vertica Database loads
Hands on experience working in data migration projects• Experienced of working in MS SQL/ Oracle Server database.
Work with business team to understand and design ETL solution for requirements.
Hands on experience in performance tuning Informatica PowerCenter Mappings, capacity planning and developing High Volume Data Loads.
Strong experience in developing efficient SQLs for querying Vertica and ParAccel databases.
Hands on work experience with cloud technologies
Knowledge on Hadoop ecosystem is a plus
Hands on experience with version control systems like GIT.
Experienced working in an Agile environment.
Strong communication skillsHigh preference for candidates with below additional skills
Hadoop frameworks and BigData analyticsSecondary Skills
Experienced with Procedural Language development.
Exposure to Banking/Mortgage domain will be plusResponsibilities
Provide technical leadership and support for inbound/outbound data integration (ETL), maintenance/tuning of applications, data model changes, data profiling, data quality assessment, executing and monitoring incremental updates, and working with infrastructure and DBA teams to maintain multiple environments (development/test/production
Knowledge on Data Modelling and familiarity with Dimension and Fact tables design.
Strong SQL performance tuning capabilities with Vertica and ParAccel.
Strong UNIX and shell scripting experience is required Autosys scheduling experience.
Must be detail oriented and possess strong problem-solving skills.
Design, develop and test PowerCenter mappings and workflows.
Develops scripts to execute and test mappings and workflows.