Our challengeWe are seeking an experienced Ab Initio Engineer to design, develop, and support enterprise-scale data integration solutions. The ideal candidate will have strong expertise in Ab Initio ETL development, data warehousing, and SQL, with experience working in complex data environments. Banking or Financial Services domain experience is highly preferred.
Additional Information*
The base salary for this position will vary based on geography and other factors. In accordance with law, the base salary for this role if filled within Charlotte, NC is $100k - $105k/year & benefits (see below).
The RoleResponsibilities:- Design, develop, enhance, and maintain ETL workflows using Ab Initio.
- Develop and optimize complex ETL processes for large-volume data loads.
- Perform data analysis, data mapping, profiling, transformation, and validation activities.
- Create and maintain source-to-target mapping documents and technical specifications.
- Troubleshoot performance issues and optimize ETL jobs for efficiency and scalability.
- Collaborate with business analysts, data architects, and application teams to gather requirements and deliver solutions.
- Support data warehouse and reporting initiatives across multiple business functions.
- Participate in code reviews, testing, deployment, and production support activities.
- Ensure adherence to data governance, security, and compliance standards.
Requirements:- Strong experience with Ab Initio ETL Development.
- Advanced SQL skills with experience in Oracle, SQL Server, Teradata, Snowflake, or PostgreSQL.
- Strong understanding of data warehousing concepts, ETL architecture, and data modeling.
- Experience in data migration, data quality, and reconciliation processes.
- Strong knowledge of Unix/Linux scripting.
- Experience with job scheduling and workflow orchestration tools.
- Familiarity with version control systems and SDLC methodologies.
- Experience working in Agile development environments.
Preferred, but not required:- Banking, Financial Services, or Capital Markets experience.
- Experience with cloud data platforms such as AWS, Azure, or Snowflake.
- Knowledge of data governance and regulatory reporting requirements.
- Exposure to Python or automation scripting is a plus.
- Strong analytical, problem-solving, and communication skills.
We offer:- A highly competitive compensation and benefits package.
- A multinational organization with 58 offices in 22 countries and the possibility to work abroad.
- 10 days of paid annual leave (plus sick leave and national holidays).
- Maternity & paternity leave plans.
- A comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region).
- Retirement savings plans.
- A higher education certification policy.
- Commuter benefits (varies by region).
- Extensive training opportunities, focused on skills, substantive knowledge, and personal development.
- On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.
- Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups.
- Cutting edge projects at the world's leading tier-one banks, financial institutions and insurance firms.
- A flat and approachable organization.
- A truly diverse, fun-loving, and global work culture.
