Ab Initio Developer

Data and Analytics | Data Engineering

Same job available in 5 locations

Jericho, New York, United States

Jersey City, New Jersey, United States

Morristown, New Jersey, United States

New York, New York, United States

Princeton, New Jersey, United States

Position Summary

Are you an experienced, passionate pioneer in technology who wants to work in a collaborative environment? As an experienced Ab Initio ETL Developer,you will have the ability to share new ideas and collaborate on projects as a consultant without the extensive demands of travel. The Project Delivery Talent Model is designed for professionals with specialized skills that align to a current client need. Team members focus on delivering services to clients, without additional expectations related to business development or promotion. Their employment is tied to their role on a project, and they are eligible for a benefits package that is competitive for project delivery-focused professionals.

Work you’ll do/Responsibilities

As an Ab Initio ETL Developer, you will design, build, and optimize high-volume data integration pipelines for financial services clients. In this client-facing technical role, you will leverage your deep expertise in the Ab Initio platform and Oracle databases to process massive enterprise datasets securely and efficiently. You will bridge the gap between business needs and technical execution by collaborating tightly with data architects and business analysts. By translating complex requirements into scalable technical solutions, you will ensure seamless source-to-target data integration while maintaining the agility to navigate shifting deadlines and unexpected changes within a fast-paced, highly regulated environment.

• High-Volume ETL Development: Design, develop, test, and deploy complex, high-volume Extract, Transform, Load (ETL) solutions for clients using the Ab Initio platform, with a specific focus on FDC Gateway integrations.
• Data Analysis & Integration: Perform rigorous data analysis, complex data mapping, and precise source-to-target integration to ensure seamless data flow across heterogeneous enterprise systems.
• Oracle Database & Pipeline Optimization: Write, optimize, and troubleshoot advanced Structured Query Language (SQL) and Procedural Language/Structured Query Language (PL/SQL) queries. Implement the required optimizations for high-volume data handling to ensure maximum throughput and resolve latency bottlenecks.
• Requirements Translation: Collaborate directly with business analysts, data architects, and other cross-functional stakeholders to translate ambiguous business requirements into robust, scalable technical solutions.
• Agile Adaptability & Delivery: Work effectively under pressure to manage strict project deadlines, adapting swiftly to unexpected changes in client expectations, requirements, or technical constraints.
• Technical Documentation & Quality Assurance: Create and maintain clear technical documentation, data lineage mapping, and standard operating procedures to ensure sustainable delivery and seamless knowledge transfer.

The Team

Join our AI & Engineering team in transforming technology platforms, driving innovation, and helping make a significant impact on our clients' success. You’ll work alongside talented professionals reimagining and re-engineering operations and processes that are critical to businesses. Your contributions can help clients improve financial performance, accelerate new digital ventures, and fuel growth through innovation.

AI & Engineering leverages cutting-edge engineering capabilities to build, deploy, and operate integrated/verticalized sector solutions in software, data, AI, network, and hybrid cloud infrastructure. These solutions are powered by engineering for business advantage, transforming mission-critical operations. We enable clients to stay ahead with the latest advancements by transforming engineering teams and modernizing technology & data platforms. Our delivery models are tailored to meet each client's unique requirements.

Our AI & Data practice offers comprehensive solutions for designing, developing, and operating advanced Data and AI platforms, products, insights, and services. We help clients innovate, enhance, and manage their data, AI, and analytics capabilities, ensuring they can grow and scale effectively.

Qualifications

Required

• 4+ years of data engineering and ETL development experience within the Financial Services industry.
• 4+ years of hands-on experience developing complex, high-volume ETL pipelines directly on the Ab Initio platform, including demonstrable proficiency working with the FDC Gateway.
• Experience in Oracle databases, including advanced SQL, PL/SQL programming, execution plan analysis, and database performance tuning.
• Understanding of enterprise data warehousing methodologies (e.g., Kimball, Inmon) and dimensional modeling techniques (Star and Snowflake schemas) to build and populate efficient data structures.
• Experience designing robust error-handling, data reconciliation, and reject-processing frameworks to ensure pristine data quality and prevent data loss within financial pipelines.
• Hands-on experience integrating ETL deployments into modern Continuous Integration/Continuous Deployment (CI/CD) pipelines utilizing version control and automation tools such as Git, Jenkins, or Azure DevOps.

Preferred

• High-Volume Data Handling: Demonstrated expertise in applying necessary optimizations for high-volume data processing, ensuring robust performance and stability across enterprise pipelines.
• Finance & Banking Data Domain: Familiarity with finance and banking data domains, including hands-on experience in the complex transformation, mapping, and rigorous validation of financial datasets.
• Communication Skills: Consistently demonstrates clear and concise written and verbal communication skills, with the ability to articulate complex technical concepts to both engineering teams and business stakeholders.
• Resilience & Problem Solving: Exceptional ability to work under pressure, manage competing deadlines, and maintain delivery excellence amidst shifting project priorities.
• Big Data & Enterprise Data Warehousing: Proven experience working directly with, rigorously reconciling, and actively managing a large-scale Enterprise Data Warehouse (EDW) designed to support complex big data analytics and reporting initiatives.
• Modern Data Platforms & Streaming: Understanding of or working experience with distributed SQL query engines (such as Trino or Starburst) and experience integrating with real-time data pipelines utilizing Apache Kafka.
• Job Scheduling & Orchestration: Hands-on experience with modern data orchestration tools such as Apache Airflow, as well as traditional enterprise job schedulers (e.g., Control-M, AutoSys) and Unix/Linux shell scripting.
• Application Integration: Familiarity with or exposure to Java and Spring Boot based applications, particularly regarding Application Programming Interface (API) integrations and data payload handling.

For individuals assigned and/or hired to work in a remote role, Deloitte is required by law to include a reasonable estimate of the compensation range for this role. This compensation range is specific to the remote role and takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. At Deloitte, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $113,000 to $188,400.

You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, whereby an award, if any, depends on various factors, including, without limitation, individual and organizational performance.

Deloitte is committed to providing reasonable accommodations for people with disabilities. If you require a reasonable accommodation to participate in the recruiting process, please direct your inquiries to the Global Call Center (GCC) at USTalentCICInbox@deloitte.com.

Recruiting tips

From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters.

Our people and culture

Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ways of thinking, ideas, and perspectives, and bring more creativity and innovation to help solve our clients' most complex challenges. This makes Deloitte one of the most rewarding places to work.

Our purpose

Deloitte’s purpose is to make an impact that matters for our people, clients, and communities. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. Our purpose comes through in our work with clients that enables impact and value in their organizations, as well as through our own investments, commitments, and actions across areas that help drive positive outcomes for our communities. Learn more.

Professional development

From entry-level employees to senior leaders, we believe there’s always room to learn. We offer opportunities to build new skills, take on leadership opportunities and connect and grow through mentorship. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their career.

As used in this posting, "Deloitte" means Deloitte Consulting LLP, a subsidiary of Deloitte LLP. Please see https://www.deloitte.com/us/about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.

Requisition code: 365968

Job ID

365968