At NTT DATA, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees have been key factors in our company's growth and market presence. By hiring the best people and helping them grow both professionally and personally, we ensure a bright future for NTT DATA and for the people who work here.
For more than 25 years, NTT DATA Services have focused on impacting the core of your business operations with industry-leading outsourcing services and automation. With our industry-specific platforms, we deliver continuous value addition, and innovation that will improve your business outcomes. Outsourcing is not just a method of gaining a one-time cost advantage, but an effective strategy for gaining and maintaining competitive advantages when executed as part of an overall sourcing strategy.
Key Responsibilities
ETL Design & Development
- 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.
Data Analysis & Validation
- 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.
Data Warehousing
- Work with dimensional modeling concepts (star schema, snowflake schema, fact & dimension tables).
- Support the development and maintenance of data warehouse/Data Mart structures.
Testing & Support
- 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.
Collaboration
- 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.
Required Skills & Qualifications
- 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
Nice to Have
- 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, Google Cloud Platform) for data integration.
- Experience working in Agile/Scrum environments.
Education
- Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field.
About NTT DATA Services:
NTT DATA Services is a recognized leader in IT and business services, including cloud, data and applications, headquartered in Texas. As part of NTT DATA, a $30 billion trusted global innovator with a combined global reach of over 80 countries, we help clients transform through business and technology consulting, industry and digital solutions, applications development and management, managed edge-to-cloud infrastructure services, BPO, systems integration and global data centers. We are committed to our clients' long-term success. Visit nttdata.com or LinkedIn to learn more.
NTT DATA Services is an equal opportunity employer and considers all applicants without regarding to race, color, religion, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other characteristic protected by law. We are committed to creating a diverse and inclusive environment for all employees. If you need assistance or an accommodation due to a disability, please inform your recruiter so that we may connect you with the appropriate team.
This position is eligible for company benefits that will depend on the nature of the role offered. Company benefits may include 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, and additional voluntary or legally required benefits.
Never miss an opportunity! Create an alert based on the job you applied for.