Technical Specialist-Data Engg

Mployee.me; Hyderabad; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

Mployee.me is seeking an experienced Ab Initio ETL Developer in Hyderabad, India. The role focuses on development and production support across the full ETL lifecycle within a data warehouse environment.

The candidate will work with the Ab Initio toolset (GDE, Co>Op, EME, Control Center) and collaborate with stakeholders to deliver scalable data integration solutions. Proficiency in SQL/PLSQL and Shell scripting is essential.

Qualifications

• 6+ years of Ab Initio ETL development and production support experience.
• Experience across requirement gathering, estimation, ETL design, development, reviews, UAT testing, migration and production go-live implementation.
• Coordination with customer and business stakeholders to build relationships.
• Experience with the Ab Initio suite including Co>Op and EME, Continuous Flows, Control Center.
• Well-versed with Cooperating System and GDE concepts.
• Extensive experience in Graphical Development Environment (GDE) and graph creation using basic components.
• Experience in Enterprise Meta Environment (EME) version control, dependency analysis, commands, and sandboxes.
• Good experience with Ab Initio components, parallelism techniques, and graphs using data, pipeline and component parallelisms.
• Experience in installation and scheduling of jobs using Control Center.

Responsibilities

• Hands-on Data Extraction, Transformation and Loading in a Data Warehouse environment.
• Develop ETL jobs for automation and monitoring; optimize job performance.
• Create Unix wrapper scripts to handle complex transformation logic.
• Groom stories and estimate work per agile methodology, size tasks for development and deployment.
• Review FSD or business requirement documents and consult on project scope and timelines.
• Collaborate with stakeholders and team members to ensure timely delivery.

Skills

Ab Initio ETL

Production support

GDE proficiency

Control Center

Co>Op/EME

SQL/PLSQL

Shell scripting

Agile methodology

Graph development

Tools

Control Center

EME

Co>Op

GDE

Job description

Area(s) of responsibility

• 6+Years of experience on Ab Initio ETL Development & Production support experience
• Multifaceted experience in various phases of Solution Life cycle such as Requirement gathering, Estimation, ETL Design, Development, Reviews, UAT Testing, Migration and Production Go-Live Implementation.
• Coordination with Customer and business (stakeholders) to build a relationship.
• Experience with the broader Ab Initio tool suite & latest version such as Co>Op & EME, Continuous Flows, Control Center.Conduct>IT, advanced Ab Initio Components
• Should be well versed with the concepts of Cooperating System and GDE
• Extensive experience in Graphical Development Environment (GDE). Should be Able to make graphs for any given scenario using all basic components.
• Experience in Enterprise Meta Environment EME version control, dependency analysis, commands, air commands, sandboxes etc.
• Good working experience with all components of Ab Initio, Experience with various Ab initio parallelism techniques, Ab initio Graphs using Data, Pipeline & Component parallelisms
• Must have experience in Installation and scheduling of Jobs using latest version of Control Center
• Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse environment.
• Review FSD/business requirement documents and consult on project scope and timelines

Size, estimate and groom stories for development and deployment per agile methodology.

• Develop ETL jobs for automation, monitoring and responsible for job performance optimization with the use of ETL development tools or custom developed procedures.
• Implementing design decisions using design patterns and plans in Abinitio and creating Unix wrapper scripts to handle complex transformation logic.
• Experience working in an agile project development lifecycle
• Well Acquainted with Oracle SQL/PLSQL, Strong proficiency in Shell scripting
• Experience in production support and handling Incidents and providing RCA.
• Grooming junior resources in team on the technology and support.