Informatica PowerCenter/IDMC TesterUS Tech Solutions • Plano, TX
Informatica PowerCenter / IDMC Tester
US Tech Solutions • Plano, TX
2 days ago
Job type
- Full-time
Job descriptionAnalyze 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. 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. Exposure to Hadoop, Hive, Spark, and distributed data processing environments. Knowledge of Kafka and streaming data concepts. Banking and payments domain experience. Bachelor's or degree in or a related field or equivalent work experience.
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 :
Experience (Required) :
Experience (Desired) :
Education :
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.
Create a job alert for this search
Informatica PowerCenterIDMC Tester • Plano, TX
Similar jobs
Configure, customize, and implement Informatica idmc mdm saas solutions to meet business data needs.Develop, automate, and optimize mdm workflows, match / merge rules, and data integration processes ...Show more
Informatica MDM good hands on with communication skills.Work from office 2-3 times a week - 1 position.About Us : InterSources Inc, a Certified Diverse Supplier, was founded in 2007 and offers innov...Show more
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.
We guarantee 15-25 hours per week with an hourly pay of bet...Show more
ETL development for a data warehouse.Informatica Mappings, Workflows, and processes.Candidate should have hands on experience working on Informatica Power Center application upgrade or new installa...Show more
Help us succeed as our next Netflix QA Tester to perform responsibilities as a QA Tester.Stay adaptable to changing priorities and business needs.
Stay adaptable to changing priorities and business ...Show more
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.
We guarantee 15-25 hours per week with an hourly pay of bet...Show more
We're on the hunt for curious, motivated individuals to test and review online money-making opportunities featured on FinanceBuzz.
If you enjoy discovering new platforms and sharing your experience,...Show more
The nCino high level Business Analyst will be responsible for translating strategic objectives into actionable user stories, managing user acceptance testing, and delivering data-driven insights to...Show more Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.
We guarantee 15-25 hours per week with an hourly pay of bet...Show more 
GDIT has an opportunity for a dynamic and collaborative leader to join our team supporting a Federal customer in developing new, and maintaining existing, software systems in an agile environment.T...Show more
With over 75 years of excellence in Dallas-Fort Worth, Texas, UT Southwestern is committed to excellence, innovation, teamwork, and compassion.
As a world-renowned medical and research center, we st...Show more
A company is looking for a Senior Informatica Security & Infrastructure Engineer (IDMC).Key Responsibilities Lead the design and implementation of security enhancements for the Informatica IDMC e...Show more
A Senior Informatica Developer will be responsible for the complete life cycle and the management of ETL processes and database systems.
Collaborating with business, development and testing teams, t...Show more
Please use Google Chrome or Mozilla Firefox when accessing Candidate Home.By joining the American Red Cross you will touch millions of lives every year and experience the greatness of the human spi...Show more
As the global leader in high-speed connectivity, Ciena is committed to a people-first approach.Our teams enjoy a culture focused on prioritizing a flexible work environment that empowers individual...Show more
At Speechify, our mission is to ensure.Speechify’s text-to-speech products—including apps on iOS, Android, macOS, Chrome, and web—to listen to PDFs, books, docs, and web content faster, smarter, an...Show more
DoorDash is the #1 category leader in food delivery, food pickup, and convenience store delivery in the US, trusted by millions of customers every day.
As a Dasher, you’ll stay busy with a variety o...Show more
Functional TestingTest blockchain transactions| events| ledgers| and consensus flowsValidate smart contract logic| state changes| and event triggersTest API integrations between blockchain nodes an...Show more
Informatica MDM Expert
RIT Solutions • Dallas, TX, United States
Full-time
Last updated: 4 days ago • Promoted
informatica Developer
Staffing the Universe • Dallas, TX, United States
Full-time
Last updated: 4 days ago • Promoted
In-Home Product Tester – No Fees, No Experience, $25-$45 / hr
OCPA • Anna, Texas, us
Part-time +1
Last updated: 30+ days ago • Promoted
Informatica Developer
TechDigital Corporation • Dallas, TX, United States
Full-time
Last updated: 4 days ago • Promoted
Netflix QA Tester
TradeJobsWorkforce • 75301 Dallas, TX, US
Full-time
Last updated: 30+ days ago • Promoted
Remote Product Tester - $25-45 per hour
Online Consumer Panels America • McKinney, Texas, US
Remote
Part-time +1
Last updated: 30+ days ago • Promoted
Work-from-Home Tester - Try Online Side Gigs and Give Feedback
Finance Buzz • Gunter, Texas, US
Remote
Temporary
Last updated: 3 days ago • Promoted
NCino Salesforce BA
TEKsystems • Plano, TX, United States
Full-time
Last updated: 1 day ago • Promoted
Online Product Tester
Online Consumer Panels America • McKinney, Texas, US
Part-time +1
Last updated: 30+ days ago • Promoted
Performance Tester
TIBCO Software, Inc. • Dallas, TX, US
Full-time
Last updated: 14 days ago • Promoted
Mobile Application Developer
UT Southwestern • Dallas, TX, US
Full-time
Last updated: 2 days ago • Promoted
Senior Informatica Security Engineer
VirtualVocations • Mesquite, Texas, United States
Full-time
Last updated: 2 days ago • Promoted
Informatica Developer
HG Solutions • Dallas, TX, United States
Full-time
Quick Apply
Last updated: 22 hours ago • New!
IRL Technologist
American Red Cross • Dallas, TX, United States
Full-time
Last updated: 1 day ago • Promoted
Mixed Signal ASIC Test Engineer
Ciena • Dallas, TX, United States
Full-time
Last updated: 1 day ago • Promoted
Software Engineer, macOS Core Product - Mesquite, USA
Speechify • Mesquite, Texas, United States
Full-time
Last updated: 3 days ago • Promoted
Delivery Driver - No Experience Needed
DoorDash • Prosper, TX, United States
Full-time +1
Last updated: 30+ days ago • Promoted
Blockchain Tester
Tekgence Inc • Dallas, TX, US
Full-time
Last updated: 2 days ago • Promoted