3+ Ab Initio Jobs in Pune | Ab Initio Job openings in Pune

Purpose of the role

To build and maintain the systems that collect, store, process, and analyse data, such as data pipelines, data warehouses and data lakes to ensure that all data is accurate, accessible, and secure. 

Accountabilities

• Build and maintenance of data architectures pipelines that enable the transfer and processing of durable, complete and consistent data.
• Design and implementation of data warehoused and data lakes that manage the appropriate data volumes and velocity and adhere to the required security measures.
• Development of processing and analysis algorithms fit for the intended data complexity and volumes.
• Collaboration with data scientist to build and deploy machine learning models.

Analyst Expectations

• To perform prescribed activities in a timely manner and to a high standard consistently driving continuous improvement.
• Requires in-depth technical knowledge and experience in their assigned area of expertise
• Thorough understanding of the underlying principles and concepts within the area of expertise
• They lead and supervise a team, guiding and supporting professional development, allocating work requirements and coordinating team resources.
• If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard. The four LEAD behaviours are: L – Listen and be authentic, E – Energise and inspire, A – Align across the enterprise, D – Develop others.
• OR for an individual contributor, they develop technical expertise in work area, acting as an advisor where appropriate.
• Will have an impact on the work of related teams within the area.
• Partner with other functions and business areas.
• Takes responsibility for end results of a team’s operational processing and activities.
• Escalate breaches of policies / procedure appropriately.
• Take responsibility for embedding new policies/ procedures adopted due to risk mitigation.
• Advise and influence decision making within own area of expertise.
• Take ownership for managing risk and strengthening controls in relation to the work you own or contribute to. Deliver your work and areas of responsibility in line with relevant rules, regulation and codes of conduct.
• Maintain and continually build an understanding of how own sub-function integrates with function, alongside knowledge of the organisations products, services and processes within the function.
• Demonstrate understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.
• Make evaluative judgements based on the analysis of factual information, paying attention to detail.
• Resolve problems by identifying and selecting solutions through the application of acquired technical experience and will be guided by precedents.
• Guide and persuade team members and communicate complex / sensitive information.
• Act as contact point for stakeholders outside of the immediate function, while building a network of contacts outside team and external to the organisation.

All colleagues will be expected to demonstrate the Values of Respect, Integrity, Service, Excellence and Stewardship – our moral compass, helping us do what we believe is right. They will also be expected to demonstrate the Mindset – to Empower, Challenge and Drive – the operating manual for how we behave.

Join us as an IFC - ETL Developer where you will spearhead the evolution of our infrastructure and deployment pipelines, driving innovation and operational excellence. You will harness cutting-edge technology to build and manage robust, scalable and secure infrastructure, ensuring seamless delivery of our digital solutions.

To be successful as an IFC - ETL Developer you should have experience with:

• Ab-Initio design, develop, and maintain complex ETL processes and data flows using Ab-Initio platform.
• Unix, strong command-line proficiency for job scheduling, monitoring, and system administration.
• Python, develop scripts for data validation, automation, and integration tasks.
• Data Warehouse concepts/Design: Design and implement enterprise data warehouse solutions, dimensional modeling, star/snowflake schemas, and ETL architectures.
• Strong knowledge of data pipeline optimization, performance tuning, and data quality management, with a proven track-record of delivering scalable data warehousing solutions.

Some other highly valued skills include:

• AWS Cloud-based data storage and processing solutions.
• Hadoop Big data ecosystem for large-scale data processing and analytics.
• Strong problem-solving skills and ability to multi-task.
• Experience with integration of multiple data sources and toolsets.

Job Title : Ab Initio Developer

Location : Pune

Experience : 5+ Years

Notice Period : Immediate Joiners Only

Job Summary :

We are looking for an experienced Ab Initio Developer to join our team in Pune.

The ideal candidate should have strong hands-on experience in Ab Initio development, data integration, and Unix scripting, with a solid understanding of SDLC and data warehousing concepts.

Mandatory Skills :

Ab Initio (GDE, EME, graphs, parameters), SQL/Teradata, Data Warehousing, Unix Shell Scripting, Data Integration, DB Load/Unload Utilities.

Key Responsibilities :

• Design and develop Ab Initio graphs/plans/sandboxes/projects using GDE and EME.
• Manage and configure standard environment parameters and multifile systems.
• Perform complex data integration from multiple source and target systems with business rule transformations.
• Utilize DB Load/Unload Utilities effectively for optimized performance.
• Implement generic graphs, ensure proper use of parallelism, and maintain project parameters.
• Work in a data warehouse environment involving SDLC, ETL processes, and data analysis.
• Write and maintain Unix Shell Scripts and use utilities like sed, awk, etc.
• Optimize and troubleshoot performance issues in Ab Initio jobs.

Mandatory Skills :

• Strong expertise in Ab Initio (GDE, EME, graphs, parallelism, DB utilities, multifile systems).
• Experience with SQL and databases like SQL Server or Teradata.
• Proficiency in Unix Shell Scripting and Unix utilities.
• Data integration and ETL from varied source/target systems.

Good to Have :

• Experience in Ab Initio and AWS integration.
• Knowledge of Message Queues and Continuous Graphs.
• Exposure to Metadata Hub.
• Familiarity with Big Data tools such as Hive, Impala.
• Understanding of job scheduling tools.

We are looking for a Senior Database Developer to provide a senior-level contribution to design, develop and implement critical business enterprise applications for marketing systems 

1. Play a lead role in developing, deploying and managing our databases (Oracle, My SQL and Mongo) on Public Clouds.
2. Design and develop PL/SQL processes to perform complex ETL processes. 
3. Develop UNIX and Perl scripts for data auditing and automation. 
4. Responsible for database builds and change requests.
5. Holistically define the overall reference architecture and manage its overall implementation in the production systems.
6. Identify architecture gaps that can improve availability, performance and security for both productions systems and database systems and works towards resolving those issues.
7. Work closely with Engineering, Architecture, Business and Operations teams to provide necessary and continuous feedback.

1. Automate all the manual steps for the database platform.
2. Deliver solutions for access management, availability, security, replication and patching.
3. Troubleshoot application database performance issues.
4. Participate in daily huddles (30 min.) to collaborate with onshore and offshore teams.

Qualifications: 

1. 5+ years of experience in database development.
2. Bachelor’s degree in Computer Science, Computer Engineering, Math, or similar.
3. Experience using ETL tools (Talend or Ab Initio a plus).
4. Experience with relational database programming, processing and tuning (Oracle, PL/SQL, My SQL, MS SQL Server, SQL, TSQL).
5. Familiarity with BI tools (Cognos, Tableau, etc.).
6. Experience with Cloud technology (AWS, etc.).
7. Agile or Waterfall methodology experience preferred.
8. Experience with API integration.
9. Advanced software development and scripting skills for use in automation and interfacing with databases.
10. Knowledge of software development lifecycles and methodologies.
11. Knowledge of developing procedures, packages and functions in a DW environment.
12. Knowledge of UNIX, Linux and Service Oriented Architecture (SOA).
13. Ability to multi-task, to work under pressure, and think analytically.
14. Ability to work with minimal supervision and meet deadlines.
15. Ability to write technical specifications and documents.
16. Ability to communicate effectively with individuals at all levels in the company and with various business contacts outside of the company in an articulate, professional manner.
17. Knowledge of CDP, CRM, MDM and Business Intelligence is a plus.
18. Flexible work hours.

This position description is intended to describe the duties most frequently performed by an individual in this position. It is not intended to be a complete list of assigned duties but to describe a position level.