Technical Specialist-Data Engg

Birlasoft; Hyderabad; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Birlasoft is seeking an experienced Ab Initio ETL Developer with strong production support capabilities for a Hyderabad-based role. The candidate will handle data extraction, transformation, and loading in a Data Warehouse environment, and will engage in solution lifecycle activities from design through Go-Live.

The role requires hands-on experience with Ab Initio Graphical Development Environment (GDE), Control Center, EME, and related components, along with proficiency in Oracle SQL/PLSQL and

Qualifications

• Minimum 6+ years experience with Ab Initio ETL development and production support.

Responsibilities

• Co-ordinate with customers and stakeholders to ensure timely delivery.
• Develop ETL jobs for automation and optimization in Ab Initio.
• Design, review, and implement ETL workflows across the data warehouse environment.
• Provide production support including incident handling and RCA.
• Groom and mentor junior resources on technology and processes.

Skills

Ab Initio

ETL Development

Production support

Oracle SQL/PLSQL

Shell scripting

GDE

EME

Control Center

Data Warehouse

Tools

Control Center

EME

GDE

Job description

Job Description:

• 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.