Senior Software Engineer

Birlasoft; Hyderabad; On-site; INR 1,400,000 - 2,100,000; Full time

Job summary

Birlasoft in Hyderabad seeks an experienced Ab Initio ETL Developer to design, develop and support complex ETL workflows within data warehouse projects.

You will work closely with stakeholders, perform production support, and ensure timely delivery in an Agile setup, leveraging GDE, Co>Op/EME, and Control Center capabilities.

Qualifications

• 6+ years of experience on Ab Initio ETL Development & Production support.
• Experience with Ab Initio tool suite & latest version such as Co>Op & EME, Continuous Flows, Control Center.
• Extensive experience in Graphical Development Environment (GDE) and creating graphs using core components.
• Strong background in Oracle SQL/PLSQL and Shell scripting.

Responsibilities

• Develop ETL jobs for data extraction, transformation and loading in a DW environment.
• Lead design, development, reviews, UAT testing, migration and production go-live.
• Collaborate with stakeholders to gather requirements and estimate effort.

Skills

Ab Initio ETL

Production support

GDE (Graphical Development Environment

Control Center

Co>Op & EME

UNIX shell scripting

Oracle SQL/PLSQL

Data Warehouse concepts

Agile methodologies

Incident management / RCA

Tools

Ab Initio

Control Center

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.