Candidate will be responsible for the design, development, maintenance and production support for various Data Mart applications.
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
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
OpenArc is a technology consulting firm providing industry-leading technical talent placement, software development, and technology strategy services to clients nationwide. Through a unique blending of people and software, OpenArc has a business practice that delivers amazing enterprise, mobile and consumer-facing apps and the best talent for contract, contract-to-hire and direct placements for clients and partners alike.
Staffed with the most-trusted recruiting experts, elite software developers, UI/UX designers and market experts, our team provides clients with the best resources, the right techniques and world-class support resulting in powerful measurable success.