Job Description :
- We are seeking an experienced Informatica PowerCenter / IDMC Tester with strong expertise in data validation, data warehousing, and large-scale ETL / ELT processes.
- This is an onsite role and the location for this role is Charlotte, NC / Plano, TX.
- The ideal candidate will have deep SQL proficiency, hands-on experience with Informatica / IDMC, and a solid understanding of banking and payments data domains. This role requires close collaboration with developers, data engineers, and business stakeholders to ensure data accuracy, quality, and performance across enterprise data platforms.
Responsibilities :
Analyze business requirements and data mapping documents to design detailed ETL test plans, scenarios, and test cases.Perform end-to-end source-to-target data validation, including reconciliation, transformation rule verification, and data loading checks.Develop and execute complex SQL queries to validate data accuracy, completeness, consistency, truncation, and aggregation logic.Validate ETL jobs, workflows, and batch processing frameworks, including metadata-driven ETL processes.Identify, document, and track data-related defects using tools such as JIRA, HP ALM, or Octane, and work closely with development teams for resolution.Automate ETL test scripts and perform data volume, performance, and scalability testing.Validate data processing in Hadoop ecosystems, including HiveQL, HDFS file structures, and data ingestion workflows.Ensure data quality standards and governance requirements are met across all data pipelines.Collaborate effectively with cross-functional teams, including developers, data engineers, and business stakeholders.Experience (Required) :
years of experience in ETL Testing and data validation.Expert-level proficiency in SQL, including complex joins, subqueries, and performance tuning.Strong experience with Informatica PowerCenter and IDMC (Intelligent Data Management Cloud).Hands-on experience with Oracle, PL / SQL, and relational databases.Solid understanding of Data Warehousing concepts, including star and snowflake schemas.Experience with scheduling and batch frameworks such as Autosys.Working knowledge of Shell Scripting.Experience (Desired) :
Exposure to Hadoop, Hive, Spark, and distributed data processing environments.Knowledge of Kafka and streaming data concepts.Banking and payments domain experience.Education :
Bachelor's or degree in or a related field or equivalent work experience.About US Tech Solutions :
US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit
US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.