Ab initio developer – 4 to 6 years -Pune
|Large scale Data onboarding project to create Data Hub that involves extensive data profiling, implement data cleaning rules, and Data lineage for business.
ETL tool is primarily Ab Initio comprising, GDE version greater than 3.3, Mhub, Mhub Customization EME, Conduct It, Control Center, Express IT.
The successful candidate will be assigned to the BI Shared Services team for the Data SSC -ETL Team. In this role, the candidate will be
part of the Core Development team that is responsible for managing the existing CIB Ab Initio Framework along with adding enhancements
to it to meet the business needs. This is a very critical and high visibility role that interacts directly with the onsite business partners
and acts as a liaison between the Core Team and APS Prod support Team. As a technical resource, the candidate will be involved mainly in Data
and Metadata onboarding activities along with building Business and Technical Data lineages for both internal and external teams.
Roles and Responsibilities –ETL Developer
Minimum more than 6 years of Application Development work experience using Ab Initio as the ETL tool
Good working knowledge in GDE version greater than 3.0, Conduct It, Control Center, Mhub, Mhub Customization Work Bench and XML components.
Knowledge in Mhub Customization and releasing the customization with a shorter turnaround.
Solid experience with data modeling and database design for operational as well as analytical systems
More than 6 years of hands-on experience with Unix Shell Scripting
Good knowledge in Hadoop file storage and processing the files through ab initio environment.
More than 5 years of experience with database sqls and writing complex queries and generating adhoc reports
Good experience in onboarding data and metadata for supporting Data profiling activities.
Good understanding of KDE, KQI and creating DMRs for Data profiling activities.
Knowledge of version and revision control practices and procedures
Strong teamwork skills and be a good liaison between Func and Prod support team.
Excellent communication skills, both verbal and written
Ability to work well in a team oriented, agile environment
Strong analytical skills and eagerness to learn new technologies