Job description

About the role As an ETL Test Engineer with Informatica , you will make an impact by designing, developing, and supporting scalable data integration solutions that enable accurate and timely business reporting and analytics. You will be a valued member of the Data Engineering team and work collaboratively with business analysts, developers, database administrators, and other stakeholders to deliver high-quality data solutions. In this role, you will: • Design, develop, and maintain ETL workflows using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS). • Perform data extraction, transformation, and loading (ETL) activities across multiple source and target systems. • Develop and implement source-to-target mappings and business transformation rules. • Create, optimize, and maintain complex SQL queries, stored procedures, and database objects. • Monitor ETL jobs, troubleshoot production issues, and ensure compliance with service-level agreements. • Conduct data validation, reconciliation, and quality checks to ensure data accuracy and integrity. • Optimize Informatica mappings, workflows, and SQL performance to support efficient data processing. • Collaborate with business analysts, developers, and database administrators to gather requirements and deliver effective data integration solutions. • Support data warehouse and data mart development initiatives. • Prepare and maintain technical documentation, deployment guides, and support documentation. Work model At Cognizant, we strive to provide flexibility wherever possible, and we are here to support a healthy work-life balance through our various wellbeing programs. Based on this role's business requirements, this is an onsite position requiring five days a week in a client or Cognizant office in Cincinnati, Ohio. The working arrangements for this role are accurate as of the date of posting. This may change based on the project you're engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations. What you need to have to be considered • Strong experience with Informatica PowerCenter and/or Informatica IICS development and support. • Proficiency in SQL, including complex queries, joins, stored procedures, and performance tuning. • Hands-on experience in ETL design, development, and data integration projects. • Strong understanding of data warehousing concepts, dimensional modeling, and database design. • Experience working with relational databases such as Oracle, SQL Server, Teradata, or Snowflake. • Ability to perform data analysis, data validation, and data quality checks. • Experience troubleshooting and resolving ETL workflow and production support issues. • Strong communication and collaboration skills with business and technical stakeholders. These will help you stand out • Experience supporting enterprise data warehouse and data mart environments. • Expertise in Informatica performance tuning and optimization. • Experience working in large-scale data migration and integration projects. • Knowledge of cloud data platforms and modern data architectures. • Familiarity with Agile development methodologies and DevOps practices. We're excited to meet people who share our mission and can make an impact in a variety of ways. Don't hesitate to apply, even if you only meet the minimum requirements listed. Think about your transferable experiences and unique skills that make you stand out as someone who can bring new and exciting things to this role. Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements: Medical/Dental/Vision/Life Insurance Paid holidays plus Paid Time Off 401(k) plan and contributions Long-term/Short-term Disability Paid Parental Leave Employee Stock Purchase Plan Cognizant will only consider applicants for this position who are legally authorized to work in the United States without company sponsorship. *Please note, this role is not able to offer visa transfer or sponsorship now or in the future* About Cognizant: Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, bridging the gap between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, drive tangible outcomes and keep global enterprises ahead in a fast-changing world. See how at cognizant.ai or @cognizant. Additional employment information Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law. Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview. Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, state or local laws. If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email CareersNA2@cognizant.com for roles based in the Americas or CareersIndia2@cognizant.com for roles based in India.

Requirements

Must-haves

Design, develop, and maintain ETL workflows using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS).
Perform data extraction, transformation, and loading (ETL) activities across multiple source and target systems.
Develop and implement source-to-target mappings and business transformation rules.
Create, optimize, and maintain complex SQL queries, stored procedures, and database objects.
Monitor ETL jobs, troubleshoot production issues, and ensure compliance with service-level agreements.
Conduct data validation, reconciliation, and quality checks to ensure data accuracy and integrity.
Optimize Informatica mappings, workflows, and SQL performance to support efficient data processing.
Collaborate with business analysts, developers, and database administrators to gather requirements and deliver effective data integration solutions.
Support data warehouse and data mart development initiatives.
Prepare and maintain technical documentation, deployment guides, and support documentation.
What you need to have to be considered
Strong experience with Informatica PowerCenter and/or Informatica IICS development and support.
Proficiency in SQL, including complex queries, joins, stored procedures, and performance tuning.
Hands-on experience in ETL design, development, and data integration projects.
Strong understanding of data warehousing concepts, dimensional modeling, and database design.
Experience working with relational databases such as Oracle, SQL Server, Teradata, or Snowflake.
Ability to perform data analysis, data validation, and data quality checks.
Experience troubleshooting and resolving ETL workflow and production support issues.
Strong communication and collaboration skills with business and technical stakeholders.
These will help you stand out
Experience supporting enterprise data warehouse and data mart environments.
Expertise in Informatica performance tuning and optimization.
Experience working in large-scale data migration and integration projects.
Knowledge of cloud data platforms and modern data architectures.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlrestagileai

Platform: cognizant
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Paid Time Off

Parental Leave