Candidate will be responsible for the design, development, maintenance and production support for various Data Mart applications.

RESPONSIBILITIES

• Design and develop complex Informatica mappings

• Create Power Exchange data map to read mainframe files

• Perform performance tuning whenever any bottleneck is identified in existing or new mappings.

• Write SQL query to perform testing and data analysis

• Write scripts of end to end unit testing

• Create CA7 Jobs for scheduling

• Closely work with Data molder, Business analysis, Data analysis and Test Lead and provide input if required

• Work daily with Customer and provide status updates of ongoing development work and work as the onsite coordinator and mentor for offshore developers

• Document ETL requirements and turn them into ETL jobs

• Understand ETL performance tuning and troubleshooting opportunities

• Perform data analysis and troubleshooting

• Analysis, diagnosis, and resolution of technical issues relating to development of ETL applications

• Responsible for participating in code reviews

REQUIREMENTS

• Bachelor’s degree or equivalent experience

• 5+ years of experience working with Informatica

• Must have experience with ETL

• Strong data modeling skills

• Has developed power center/Power Exchange