Informatica Python ETL Data Engineer & Tester
Hi,Hope you are doing good!We have a Full-time opportunity for you as Informatica Python ETL Data Engineer & Tester @ Hartford, CT, Raleigh, NC, Richardson, TX, Tempe, AZRole: Informatica Python ETL Data Engineer & TesterLocations: Hartford, CT, Raleigh, NC, Richardson, TX, Tempe, AZType of Hiring: FTERequired Skill and Experience• Informatica development, Python, AWS, SQL, Oracle, and GitLab.• ETL Testing, Data Warehouse Testing, and Data Migration Testing.• Python-based ETL and data test automation for source-to-target validation, reconciliation, and regression testing.• SQL query writing and Oracle database validation.• Source-to-target mapping validation, transformation rule validation, data lineage validation, and business rule validation.• Data reconciliation, completeness checks, referential integrity validation, duplicate detection, and data quality testing.• Data Warehousing concepts including Facts, Dimensions, Star Schema, and SCD validations.• AWS data platform validation.• GitLab, batch job validation, workflow monitoring, and scheduling tools such as Autosys, Control-M, or Airflow.• Python or Shell scripting for ETL and data validation activities.• Test strategy preparation, test case execution, result analysis, and defect resolution.• Collaboration with business teams, development teams, and data engineering teams.• Documentation of test scenarios, SQL validations, automation assets, and testing processesPreferred Skill and Experience• BI Reporting validation using Power BI, Tableau, Qlik, or MicroStrategy.• Big Data technologies including Hadoop, Spark, Hive, and Kafka.• AI-enabled Data Quality and Data Governance solutions.• Banking, Capital Markets, Wealth Management, or Mortgage domain experience.• Azure, Databricks, Snowflake, Redshift, PostgreSQL, BigQuery, or GCP exposure.