NTT DATA North America · 4 hours ago
Informatica Powercenter Developer
Salt Lake City, UT
Full-time
Onsite
Senior Level
5+ years expNTT DATA North America is a recognized leader in IT and business services. They are seeking an Informatica Powercenter Developer to design and develop ETL workflows, optimize data integration pipelines, and support data warehousing efforts.
ConsultingDigital MarketingInformation ServicesInformation TechnologyIT Management
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
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
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 North America
NTT DATA, Inc. is a trusted global innovator of business and technology services.
10001+ employees
H1B Sponsorship
NTT DATA North America 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)
Funding
Current Stage
Late StageLeadership Team
John Barr
Vice President - Insurance Strategy
Recent News
2025-12-05
Company data provided by crunchbase