Apply on Employer Site

NTT DATA · 20 hours ago

Informatica Powercenter Developer

Salt Lake City, UT

Full-time

Onsite

Senior Level

5+ years exp

NTT DATA is a recognized leader in IT and business services, and they are seeking an Informatica Powercenter Developer. The role involves designing and developing ETL workflows, performing data analysis, and collaborating with various stakeholders to ensure effective data integration and warehousing.

Application Performance ManagementCloud ManagementEnterprise SoftwareInformation Technology

H1B Sponsor Likely

Responsibilities

Design, develop, and maintain ETL workflows using Informatica PowerCenter

Build robust ETL mappings, sessions, and workflows to support various business processes

Perform data extraction, transformation, and loading from heterogeneous data sources (RDBMS, flat files, XML, APIs, etc.)

Optimize ETL performance and ensure scalable, high performing data integration pipelines

Conduct data analysis to understand source systems and identify data quality issues

Implement data validation, cleansing, and reconciliation processes

Collaborate with business analysts and data architects to translate requirements into technical specifications

Work with dimensional modeling concepts (star schema, snowflake schema, fact & dimension tables)

Support the development and maintenance of data warehouse/Data Mart structures

Conduct unit testing, integration testing, and performance testing of ETL components

Provide production support for ETL jobs, troubleshoot failures, and ensure SLA adherence

Document design specifications, technical processes, and operational procedures

Partner with DBAs, architects, QA teams, and business stakeholders to deliver end to end ETL solutions

Participate in code reviews, design discussions, and continuous improvement initiatives

Qualification

Informatica PowerCenterSQL optimizationData warehousing conceptsWorkflow scheduling toolsUnix/Linux scriptingData analysisDebugging skillsAgile/Scrum experienceInformatica CloudBig data exposureCloud platforms familiarityCommunication skillsTeam collaboration

Required

5+ years of hands on experience in ETL development using Informatica PowerCenter

Strong proficiency in writing and optimizing SQL (Oracle, SQL Server, or similar)

Solid understanding of data warehousing concepts, ETL best practices, and data modelling techniques

Experience with workflow scheduling tools (Control-M, Autosys, Tivoli, etc.)

Good knowledge of Unix/Linux shell scripting for automation and troubleshooting

Ability to analyze complex data sets and resolve data quality issues

Strong debugging skills and experience in performance tuning of mappings, sessions, and SQL queries

Excellent communication skills and the ability to work collaboratively in a team environment

Must be onsite in Salt Lake City, UT

Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field

Preferred

Experience with Informatica Cloud (IICS) or Informatica Intelligent Cloud Services

Exposure to big data ecosystems (Hadoop, Spark, Hive) is a plus

Familiarity with cloud platforms (Azure, AWS, GCP) for data integration

Experience working in Agile/Scrum environments

Benefits

Medical, dental, and vision insurance

Flexible spending or health savings account

Life, and AD&D insurance

Short-and long-term disability coverage

Paid time off

Employee assistance

Participation in a 401k program with company match

Additional voluntary or legally required benefits

Company

NTT DATA

Glassdoor3.9

NTT Data specializes in SAP services for enterprises and offers IT consultation, application and cloud management, and SAP implementation.

Founded in 1967

Plano, Texas, USA

10001+ employees

https://nttdata-solutions.com/cz/

H1B Sponsorship

NTT DATA has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (144)

2024 (182)

2023 (257)

2022 (871)

2021 (809)

2020 (1266)