16 days ago
USA (city not specified)Mid Level
Responsibilities
- Document assigned business requirements and participate in software application design discussions.
- Participate in coding, feature integration, code reviews, repository maintenance, and software changes.
- Develop Python-based ETL and data test automation for source-to-target validation, reconciliation, and regression testing.
- Execute ETL, data warehouse, data migration, data quality, and AWS data platform validation.
- Validate SQL queries, Oracle databases, source-to-target mappings, transformation rules, data lineage, business rules, referential integrity, completeness, duplicates, and data reconciliation.
- Prepare test strategies, execute test cases, analyze results, coordinate defect resolution, and monitor batch jobs and workflows.
- Support production issue resolution, recommend preventive strategies, and maintain technical, testing, and support documentation.
- Develop user training programs, documentation, and support frameworks for new software applications.
- Collaborate with business teams, development teams, and data engineering teams.
Requirements
- Bachelor’s degree or foreign equivalent from an accredited institution, or progressive experience in lieu of education as stated in the posting.
- Experience with Informatica development, Python, AWS, SQL, Oracle, and GitLab.
- Experience with ETL testing, data warehouse testing, data migration testing, and Python or Shell scripting for data validation.
- Knowledge of data warehousing concepts including facts, dimensions, star schemas, and slowly changing dimension validations.
- Experience with test strategy preparation, test case execution, result analysis, defect resolution, workflow monitoring, and scheduling tools.
- Ability to document test scenarios, SQL validations, automation assets, and testing processes.
- Preferred experience with Power BI, Tableau, Qlik, or MicroStrategy.
- Preferred experience with Hadoop, Spark, Hive, Kafka, AI-enabled data quality and governance solutions, and banking or capital markets domains.
- Exposure to Azure, Databricks, Snowflake, Redshift, PostgreSQL, BigQuery, or GCP.
Benefits
- Medical, dental, vision, and life insurance.
- Long-term and short-term disability coverage.
- Health and dependent care reimbursement accounts.
- Accident, critical illness, hospital indemnity, and legal insurance.
- 401(k) plan with contributions dependent on salary level.
- Paid holidays and paid time off.
- The position may require relocation and/or travel to the work or project location.
- Full-time Infosys employees are eligible for the listed benefits.
Tech Stack
Amazon RedshiftApache AirflowApache HadoopApache HiveApache KafkaApache SparkAWSAzureDatabricksGoogle BigQueryGoogle Cloud PlatformInformaticaPostgreSQLPythonSnowflakeSQL
Categories
Data EngineeringTesting
About Infosys
Infosys is a public IT services and consulting company that builds and runs software systems for large enterprises across industries. It provides consulting, systems integration, cloud and AI services, engineering, and business process outsourcing, and sells platforms such as EdgeVerve's Finacle core banking suite. Founded in 1981 and headquartered in Bangalore, it serves clients in 50+ countries and is listed on the NSE, BSE, and NYSE.