What are the responsibilities and job description for the Automation Engineer (Data Conversion / ETL Tester) position at capgemini?
Key Responsibilities:
Validate end-to-end data migration processes across source and target systems
Develop test scenarios and test cases for ETL mappings transformations and data quality checks
Execute data validation reconciliation and balancing across large datasets
Perform SQLbased testing to verify data accuracy completeness and integrity
Identify data defects document issues with clear rootcause indicators and work with ETLdev teams for resolution
Conduct pre and postconversion testing including historical data validation and incremental loads
Ensure compliance with business rules transformation logic and data governance requirements
Required Skills:
Strong experience in data migration or ETL testing Informatica SSIS DataStage or similar
Proficient in SQL for complex queries joins aggregations and data profiling
Experience with large data sets data warehousing concepts and relational databases
Understanding of business rules data mapping and transformation logic
Handson experience with test management and defect tracking tools
Nice to Have:
Experience with cloud data platforms Azure AWS GCP
Knowledge of automation frameworks for ETL testing
Banking or financial domain experience
The pay range that the employer in good faith reasonably expects to pay for this position is $28.66/hour - $44.78/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.
Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.
Salary : $29 - $45