AWS Python ETL Data Tester
Infosys
A complete application in a minute
Tailored resume and cover letter, ready to send.
Benefits offered by this job
Job summary
Infosys is seeking a Tech Consultant in the U.S. to support ETL testing and data quality initiatives within the Financial Services unit. The role focuses on documenting requirements, designing robust data solutions, and validating data across platforms.
You will code, review, and integrate features while ensuring stability and quality across BI and data pipelines. Candidate will collaborate with business, development, and data engineering teams, handling production issues and delivering
Qualifications
- Experience in ETL testing and data validation across data warehouses.
- Strong Python scripting for automation in data pipelines.
- Proficient in SQL with validation across Oracle, SQL Server, BigQuery.
- Knowledge of cloud platforms (AWS/Azure/GCP) and data services.
- Familiarity with BI validation and data governance concepts.
- Ability to work across cross-functional teams and SDLC.
Responsibilities
- Document business requirements for assigned parts per guidance.
- Lead design discussions and document decisions for implementation.
- Code and integrate features while maintaining stability.
- Perform code reviews and manage code repositories.
- Plan test strategies, execute cases, and coordinate defects.
- Develop user training, documentation, and support guides.
- Resolve production issues and suggest preventive measures.
- Maintain thorough records of tests, SQL validations, and processes.
Skills
Education
Tools
Job description
The Infosys Financial Services unit is a global leader in driving digital transformation for financial institutions. We specialize in leveraging advanced technologies such as AI, cloud, and data-led innovation to help our clients accelerate growth and unlock business value. Our AI-driven solutions empower financial institutions to make smarter decisions, enhance customer experiences, and achieve operational excellence. Join us to be part of a pioneering team that is at the forefront of financial services transformation. You'll have the opportunity to work with cutting-edge AI technologies, collaborate with industry experts, and contribute to transformative projects across banking, wealth management, and insurance sectors. If you're passionate about AI and eager to make a significant impact, the Infosys Financial Services unit is the perfect place for you to grow and excel.
The Infosys Financial Services unit is a global leader in driving digital transformation for financial institutions. We specialize in leveraging advanced technologies such as AI, cloud, and data-led innovation to help our clients accelerate growth and unlock business value. Our AI-driven solutions empower financial institutions to make smarter decisions, enhance customer experiences, and achieve operational excellence. Join us to be part of a pioneering team that is at the forefront of financial services transformation. You'll have the opportunity to work with cutting-edge AI technologies, collaborate with industry experts, and contribute to transformative projects across banking, wealth management, and insurance sectors. If you're passionate about AI and eager to make a significant impact, the Infosys Financial Services unit is the perfect place for you to grow and excel.
The Infosys Financial Services unit is a global leader in driving digital transformation for financial institutions. We specialize in leveraging advanced technologies such as AI, cloud, and data-led innovation to help our clients accelerate growth and unlock business value. Our AI-driven solutions empower financial institutions to make smarter decisions, enhance customer experiences, and achieve operational excellence. Join us to be part of a pioneering team that is at the forefront of financial services transformation. You'll have the opportunity to work with cutting-edge AI technologies, collaborate with industry experts, and contribute to transformative projects across banking, wealth management, and insurance sectors. If you're passionate about AI and eager to make a significant impact, the Infosys Financial Services unit is the perfect place for you to grow and excel.
- Contribute to the requirements elicitation process by documenting assigned parts of business requirements, in line with guidance provided
- Facilitate software application design discussions, and document design decisions to guide the technical team towards building software solutions
- Participate in coding and integrate new features or updates into existing applications, with a focus on maintaining system stability
- Conduct code reviews, do changes to the codebase and maintain code repositories
- Implement test strategies, analyse results, and coordinate bug fixes to uphold the software quality standards
- Develop user training programs, documentation, and support frameworks to ensure a smooth transition to new software applications
- Actively participate in resolving production issues and recommend preventive strategies to enhance system reliability
- Maintain detailed records of code, testing techniques, and support activities to enrich the knowledge base and assist other similar projects
- A collaborative spirit and excellent communication skills.
- The ability to handle end to end SDLC phases from requirement gathering to implementation.
- A knack for translating complex requirements into actionable development tasks.
- A passion for design and hands-on coding experience
- A proactive approach to testing, troubleshooting, and refining our applications.
- The ability to work with cross-functional teams and do software integration.
- Experience in Data/ETL Testing.
- Experience in Python-based ETL test automation.
- Experience in ETL Testing, Data Warehouse Testing, and Data Migration Testing.
- Develop automation solutions using Python/Shell scripting for ETL and data validation activities.
- Experience in SQL and database validation across Oracle, SQL Server, PostgreSQL, Snowflake, AWS Redshift, or BigQuery.
- Validate source-to-target mappings, transformation rules, data lineage, and business logic as per mapping documents.
- Perform data reconciliation, completeness checks, referential integrity, duplicate detection, and data quality validations.
- Experience in ETL tools such as Informatica, Ab Initio, ODI, SSIS, DataStage, Azure Data Factory, or Databricks.
- Strong understanding of Data Warehousing concepts including Facts, Dimensions, Star Schema, and SCD validations.
- Experience validating cloud-based data platforms on AWS, Azure Databricks, Snowflake, or GCP.
- Hands-on experience with batch job validation, workflow monitoring, and scheduling tools such as Autosys, Control-M, or Airflow.
- Implement test strategies, prepare and execute test cases, analyze results, and coordinate defect resolution to ensure data quality.
- Collaborate with business, development, and data engineering teams to ensure accurate and reliable data delivery.
- Maintain detailed documentation of test scenarios, SQL validations, automation assets, and testing processes.
- Experience in BI Reporting validation using Power BI, Tableau, Qlik, or MicroStrategy.
- Experience in Big Data technologies such as Hadoop, Spark, Hive, and Kafka.
- Knowledge of AI-enabled Data Quality and Data Governance solutions.
- Banking, Capital Markets, Wealth Management, or Mortgage domain experience.
- Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
- This position may require relocation and/or travel to work/project location.
- All applicants authorized to work in the United States are encouraged to apply.
Along with competitive pay, as a full-time Infosys employee you are also eligible for the following benefits:
- Medical/Dental/Vision/Life Insurance
- Long-term/Short-term Disability
- Health and Dependent Care Reimbursement Accounts
- Insurance (Accident, Critical Illness , Hospital Indemnity, Legal)
- 401(k) plan and contributions dependent on salary level
- Paid holidays plus Paid Time Off
Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.
Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
