Lead ETL Developer Informatica
- Location
- King of Prussia, PA
- Listed
- Yesterday
How well does your resume fit this job?
Upload your resume to see your score for this Atria Group role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
This position is responsible for solving data integration challenges using Informatica as the data integration platform. He/she will be involved in understanding the data integration and transformational requirements as laid by the business requirement / data architect and convert those into ETL routines using Informatica.
He/She would be responsible for the development of routines, preparing test cases and testing the ETL jobs for the data validation. He/she will be responsible for checking the accuracy of the mappings through reconciling the source, target systems and any rejects. Should provide guidance to the junior members of the team.
Primary Responsibilities
- Develop ETL routines with Informatica 9.1/9.5
- Develop test cases for the ETL mappings and prepare test scripts in line with the data integration/transformation requirements
- To script SQL queries in the source and target system in order to ensure data validation/data reconciliation
- Develop ETL routines for OLTP and BI systems and develop mappings for facts and scd1/2 dimensions
- Profile the data with tool and SQL queries to identify the data which does not conform to business rule and database integrity
- Scheduling of the ETL jobs through scheduler and scripts to ensure the correct data flow sequence
- Performance tuning of the mapping as per the batch load timings
General qualifications & experience
Education: BE/B.Tech in Engineering discipline
Around 7-8 years of experience in following work areas
- ETL development using Informatica 9.1/9.5 and detailed knowledge of different features of the tool to handle data transformation requirement
- Should have worked in data warehousing and data migration project with large scale data transformation, knowledge of ETL development procedures
- Knowledge of data profiling techniques for data analysis using SQL and ETL tool
- Extremely good at SQL
- Very good knowledge of the database structures/systems and proficient in writing complex SQL routines
- Experience of performance tuning of ETL mappings
- Knowledge of ETL schedulers and basic knowledge of Unix shell scripting
- Knowledge of SDLC and quality processes to be followed in a data integration project – prepare test plan, test cases and test scripts and reviews
Qualifications & Requirements
- Submit your resume today!
- This is a C2P opp.
Additional Information:
From Atria Group's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Lead ETL Developer Informatica role at Atria Group, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
More at Atria Group
All Atria Group jobsCommon questions
Where is the Lead ETL Developer Informatica job at Atria Group located?
This Lead ETL Developer Informatica position at Atria Group is located in King of Prussia, PA. Always check Atria Group's application page for specific state eligibility or relocation policies.
How do I apply for the Lead ETL Developer Informatica position at Atria Group?
This listing links directly to Atria Group's SmartRecruiters application page. You can apply directly on Atria Group's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.