EDW Consultant

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

NTT DATA's Client is currently seeking a EDW Consultant to join their team in Pittsburgh, Pennsylvania (US-PA), United States (US). REMOTE!

Job Description:

• Provides systems analysis, design, development, testing and support for moderately complex technical information system components.

Essential Functions

• Understands and develops components and services according to specifications within a team environment.
• Prepares detailed system documentation including requirements, specifications, test plans and user manuals.
• Performs unit and system tests and, as needed, validation testing.
• Assists DBA with database design and implementation.
• Strong SQL and Analytical skills to pull data from Snowflake/Oracle/SQL Server and perform usage analysis and/or data profiling.
• Understanding of data warehousing and data modelling principles
• Experience in understanding both logical and physical data models
• Coordinates with Operations staff on deployment of applications.
• Works with business partners to analyze and address support requests including training.
• Provides support for existing systems and technologies, including second line application support during and after deployment.
• Ensures all activities are performed with quality and compliance.
• Design and implementation of ETL batches that meet the SLAs for the business' Business Intelligence reporting.
• Development of data collection, data staging, data movement, data quality and archiving strategies.
• Plan and conduct ETL Unit and development tests, monitoring results and taking corrective action when necessary.
• Design and implement automation processes to control data access, transformation and movement and ensures source system data availability

Knowledge, Skills and Abilities

• Must have 12+ year's experience who has min 3 year's experience in Talend and min 7+ year's experience in SQL and EDW.
• Experienced in the use of the Talend ETL tool and Snowflake/Any Cloud based tools (Must Have)
• Experience in connecting to REST API's and posting the data via API using Talend ELT tool (Must have)
• Good hands on Talend Administration managing remote engines, debugging and fixing Java/JVM issues, perform upgrades, Talend Management Console etc
• Client focused approach with strong interpersonal skills
• Must be able to multitask and pay close attention to detail
• Open to PROD support during the week and weekends in US EST hours
• Solid knowledge of basic relational database platforms (Snowflake/RedShift, Oracle, SQL Server) and languages (PL/SQL, SQL) (Must Have)
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Strong logic, analysis, and problem-solving skills
• A good understanding of the concepts and best practices of data warehouse ETL design. (Must Have)
• Ability to follow functional ETL specifications and challenge business logic and schema design where appropriate, as well as manage their time effectively
• Expertise in building and optimizing cloud data pipelines, architectures and data sets.

About NTT DATA:

NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com
 

Where required by law, NTT DATA provides a reasonable range of compensation for specific roles. The starting hourly range for this remote role is $50 TO $60.  This range reflects the minimum and maximum target compensation for the position across all US locations. Actual compensation will depend on several factors, including the candidate's actual work location, relevant experience, technical skills, and other qualifications. This position may also be eligible for incentive compensation based on individual and/or company performance.

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.

NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.