Senior Consultant 1- Abinitio Developer

At Allstate, great things happen when our people work together to protect families and their belongings from life’s uncertainties. And for more than 90 years our innovative drive has kept us a step ahead of our customers’ evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection. 

Job Description

• An Ab Initio Developer should have hands-on exposure to Ab Initio ETL and should be proficient in Oracle SQL,PL/SQL
• Designed, developed, tested and implemented Ab Initio ETL graphs with complex transformations.
• In Depth understanding and Practical knowledge on Partitioning, Multifile systems.
• Dealt with various source system formats such as XML, XLS, AVRO, JSON, DB, Parquet files.
• Well-versed with creating Plans, Continuous flows, BRE, Data profiling.
• Hands-on with Generic programming, Dynamic scripts generation, Dealing with PDL functions and custom components handling.
• Resolving incident/problem/known errors management and pro-actively identifying, addressing, and monitoring any issues coming up in Production
• Can evaluate technical designs and data mapping documents, in partnership with onshore designers and developers, based on user requirements.
• Responsible for designing and running user acceptance tests and implementing software changes as per business requirements. Participate in code reviews, and test plan reviews.
• Work with QC Analyst to ensure appropriate conditions are identified, provide technical expertise on execution of applications, and support QC processes.
• Generated and delivered large volume of DWH applications & Perform performance tuning on both UNIX ETL and Oracle database environments.
• Developed Wrappers scripts and automate through schedulers.
• Involved in Production migration and support the developed applications with continuous Customer Interaction to better understand and gather requirements.

Shift Timing
 

1 PM - 9:30 PM

Primary Skills

Shift Time

Recruiter Info

About Allstate

Joining our team isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good.  

You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven that Allstate empowers everyone to lead, drive change and give back where they work and live. 

Good Hands. Greater Together.®

The Allstate Corporation is one of the largest publicly held insurance providers in the United States. Ranked No. 84 in the 2023 Fortune 500 list of the largest United States corporations by total revenue, The Allstate Corporation owns and operates 18 companies in the United States, Canada, Northern Ireland, and India. Allstate India Private Limited, also known as Allstate India, is a subsidiary of The Allstate Corporation. The India talent center was set up in 2012 and operates under the corporation's Good Hands promise. As it innovates operations and technology, Allstate India has evolved beyond its technology functions to be the critical strategic business services arm of the corporation. With offices in Bengaluru and Pune, the company offers expertise to the parent organization’s business areas including technology and innovation, accounting and imaging services, policy administration, transformation solution design and support services, transformation of property liability service design, global operations and integration, and training and transition.

Learn more about Allstate India here.