Logo of Huzzle

Ab initio | 3 to 6 years | Pune | Chennai

image

Capgemini

11d ago

  • Job
    Full-time
    Mid & Senior Level
  • Data
    IT & Cybersecurity
  • Chennai

AI generated summary

  • You should have 3-6 years of Ab Initio experience, SQL proficiency, UNIX skills, project lifecycle knowledge, data modeling, finance expertise, and familiarity with CI/CD concepts and scheduling tools.
  • You will develop graphs, produce LLD, support testing, handle complex data ingestion patterns, create data models, and ensure system interaction with hardware while working in an agile environment.

Requirements

  • Ab Initio Skills: Graph Development, Ab Initio standard environment parameters, GD(PDL,MFS Concepts)E, EME basics, SDLC, Data Analysis
  • Database: SQL Proficient, DB Load / Unload Utilities expert, relevant experience in Oracle, DB2, Teradata (Preferred)
  • UNIX: Shell Scripting (must), Unix utilities like sed, awk, perl, python
  • Scheduling knowledge (Control M, Autosys, Maestro, TWS, ESP)
  • Project Profiles: Atleast 2-3 Source Systems, Multiple Targets, simple business transformations with daily, monthly
  • Expected to produce LLD, work with testers, work with PMO and develop graphs, schedules, 3rd level support
  • Should have hands on development experience with various Ab Initio components such as Rollup Scan, join Partition, by key Partition, by Round Robin. Gather, Merge, Interleave Lookup etc
  • Experience in finance and ideally capital markets products.
  • Requires experience in development and support of complex frameworks to handle multiple data ingestion patterns.e.g, messaging files,hierarchical polymorphic xml structures conformance of data to a canonical model curation and distribution of data QA Resource.
  • Data modeling experience creating CDMs LDMs PDMs using tools like ERWIN, Power designer or MagicDraw.
  • Detailed knowledge of the capital markets including derivatives products IRS CDS Options structured products and Fixed Income products.
  • Knowledge on Jenkins and CICD concepts. Knowledge on scheduling tool like Autosys and Control Center.
  • Demonstrated understanding of how AbInitio applications and systems interact with the underlying hardware ecosystem.
  • Experience working in an agile project development lifecycle.
  • Strong in depth knowledge of databases and database concepts DB2 knowledge is a plus

Responsibilities

  • Expected to produce LLD, work with testers, work with PMO and develop graphs, schedules, 3rd level support
  • Should have hands on development experience with various Ab Initio components such as Rollup Scan, join Partition, by key Partition, by Round Robin. Gather, Merge, Interleave Lookup etc
  • Requires experience in development and support of complex frameworks to handle multiple data ingestion patterns.e.g, messaging files,hierarchical polymorphic xml structures conformance of data to a canonical model curation and distribution of data QA Resource
  • Data modeling experience creating CDMs LDMs PDMs using tools like ERWIN, Power designer or MagicDraw
  • Demonstrated understanding of how AbInitio applications and systems interact with the underlying hardware ecosystem
  • Experience working in an agile project development lifecycle
  • Strong in depth knowledge of databases and database concepts DB2 knowledge is a plus

FAQs

What are the key skills required for this Ab Initio position?

The key skills required include Ab Initio graph development, SQL proficiency, shell scripting in UNIX, scheduling knowledge (e.g., Control M, Autosys), and experience with database load/unload utilities.

What is the expected experience level for applicants?

Applicants are expected to have 3 to 6 years of experience in relevant fields.

Which databases should the candidates have experience with?

Candidates should have relevant experience with databases such as Oracle, DB2, and Teradata. SQL proficiency is also a must.

Is experience in the finance sector necessary?

Yes, experience in finance, particularly with capital markets products, is preferable.

What project management methodologies should candidates be familiar with?

Candidates should have experience working in an Agile project development lifecycle.

Are there any specific UNIX skills required for this position?

Yes, candidates must have strong shell scripting skills and familiarity with UNIX utilities such as sed, awk, perl, and python.

What tools should candidates know for scheduling?

Candidates should have knowledge of scheduling tools like Control M, Autosys, Maestro, TWS, or ESP.

What kind of documentation is expected from the candidates?

Candidates are expected to produce Low-Level Designs (LLD) and work closely with testers and project management offices (PMO).

What Ab Initio components should candidates have hands-on experience with?

Candidates should have hands-on experience with various Ab Initio components, including Rollup Scan, join Partition, and Lookup functions.

Is knowledge of cloud platforms relevant for this role?

Yes, knowledge of AWS tools such as AWS S3, AWS Redshift, as well as Azure tools, is relevant for this position.

Do candidates need experience with data modeling?

Yes, candidates should have experience creating Conceptual Data Models (CDMs), Logical Data Models (LDMs), and Physical Data Models (PDMs) using tools like ERWIN or Power Designer.

What is the work location for this role?

The position is open for candidates in Pune and Chennai.

Is a certification in Ab Initio required for this position?

Certification is not explicitly mentioned as a requirement, but strong Ab Initio skills and hands-on experience are crucial.

Will the role involve collaboration with other teams?

Yes, the role requires collaboration with testers, PMO, and the development team for effective project execution.

Is experience with CI/CD concepts necessary?

Yes, familiarity with CI/CD concepts, including knowledge of Jenkins and AWS Code Pipeline, is preferred.

What types of business transformations should the candidates be familiar with?

Candidates should have experience with simple business transformations involving at least 2-3 source systems and multiple targets.

Get the Future You Want

Technology
Industry
10,001+
Employees
1967
Founded Year

Mission & Purpose

Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of 360,000 team members in more than 50 countries. With its strong 55-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group reported in 2022 global revenues of €22 billion.