Job Description :
Note: consultant should be either on W2,1099 or ourpayroll

DAI – Informatica Cloud Services Lead

Summary:

The Informatica Cloud Services Lead role guides the Data Integration development team in the design, build, and deployment of the project''s data integration components using Informatica IICS technology. He/she insures that best practices are used and high quality work is delivered. He/she acts as a mentor, advisor and facilitator while providing guidance to his team. He/she has the ability to break the work into comprehensive chunks and provide accurate estimates. The ideal candidate will be responsible for leading the technical team in developing, remediating, testing and deploying Informatica IICS ETL code.

Responsibilities:


Design and develop integration patterns for IICS
Develop framework for converting existing PowerCenter mappings and workflows into IICS
Develop approach for converting mappings using PowerExchange
Create architecture/design documentation for PowerCenter to IICS conversion
Create technical specifications from business & functional requirements using the Velocity framework
Provides guidance to development team working on the Informatica IICS ETL platform
Documents and oversees adherence to best practices
Can work as a senior developer when needed
Helps defining work methodology and structure
Makes sure that quality standards are defined and met
Can provide workload estimates
Removes roadblocks that are in the way of developers
Works closely with QA testers to ensure quality
Reviews components developed by the members of his team to ensure quality
Insures developers are productive and work in an efficient manner


Skills Required:


10+ years of IT industry experience;
9+ years of Data Warehousing experience with at least 5+ years as an Informatica ETL Lead;
3+ years of Informatica administration experience (at least 1 year Admin experience with version 9.x)
3+ years of Informatica Cloud Services (ICS) experience including experience with IICS
Experience converting PowerCenter mappings and workflows to IICS and developing related frameworks to facilitate conversion
Experience installing Informatica and managing code deployments across environments
Experience using Informatica IICS against AWS cloud and on premise databases (ideally experience using IICS with on premise DB2 and AWS Aurora and Snowflake)
Experience with developing Informatica frameworks for code reusability
Understands data integration from an information management perspective
Must have experience developing and managing artifacts using the Velocity framework



Strong data modeling skills, both dimensional and relational.
Strong Advanced SQL programming skills are required
Experience with defining test strategies for ETL test automation
Proven experience with major Database systems including development, design, optimization and maintenance. Full Life Cycle Experience in Data Warehouse Design, Development, ETL Tuning and Support



Experience working with mainframe DB2, Amazon Web Services, Aurora and Snowflake databases
Understands RDBMS performance tuning (indexing, partitioning, compression, bulk loading, …)
Understands ETL parallelization concepts



Has the ability to work with business and system owners to obtain requirements and manage expectations working with both business and technical stakeholders



Proficient at data profiling and quickly understanding data structures
Ability to perform requirements gathering by asking the right questions to the right people
Extraordinary organizational skills
Excellent communications skills



Knowledge of BI tools (Tableau, Qlikview, Quicksight)
Experience working with both Waterfall and Agile methodologies
Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts. Additionally the candidate will have strong presentation, interpersonal, software development and work management skills.
Must have experience working with offshore teams


Preferred Traits:


Proactive attitude
Very good inter-people skills to effectively interface to customers, team members, and other colleagues
Very strong communication capability in English, both spoken and written
Able to work in a diversified environment
Team Player
Fast learner
Time/Project management skills


Education:


Requires a Degree (other majors acceptable with requisite experience) in a related area and at least 10 years of related experience





Regards,



Kishore,

Sr IT Recruiter. 

Gemini Consulting Services

3636 S Geyer Rd # 270, St. Louis, MO 63127, United States

Phone ext 305| Direct | Fax

 | 



" Infinite faith and strength are the only conditions of Success" - CONFIDENTIALITY NOTICE This e-mail and the documents accompanying this transmission are confidential and may be a communication privileged or protected by law. It is meant for only the intended recipient. If you received this e-mail in error, any review, use, dissemination, distribution or copying of the e-mail is strictly prohibited. Please notify the sender immediately of the error by return e-mail and please delete the message from your system. Thank you in advance for your cooperation.