Software Development Advisor Job at NTT DATA (Canton)

Job Description

We are currently seeking a Software Development Advisor to join our team in Canton, Massachusetts (US-MA), United States (US).

Perform Data analysis, collect business requirements and identify business rules
Analyze, develop and support Data Integration, EDW and Data Management using Informatica, SQL, Oracle etc. platforms and tools
Collaborate with data modelling team to define data integration logic
Create data mappings necessary to fulfill the requirements
Build and test new ETL programs to fulfill the service requests
Automate the ETL processes and pipelines using scripting and Schedulers
Participate in Unit Testing, assist QA team in Integration Testing, and support Business team for UAT
Participate in code deployment and coordinate with different infrastructure teams during go-live, post-production, and continued support of end product
Debug data quality issues by analyzing the upstream sources and provide guidance to data integration team resolutions
Work closely work with DBAs to fix performance bottlenecks

Recent experience and clear responsibilities in an ETL / Extracts / Data Engineering lead developer capacity
8 plus years of experience in data integration (ETL) with 6 or more in solution development using Informatica suite
6 or more years of experience in RDBMS / Data Warehousing platforms on Oracle
Must be an expert in Linux shell scripting to introduce automation as part of solution delivery
Strong SQL knowledge and ability to write most complex queries
Conceptual understanding of logical and physical data modelling is a must, and a working experience is a plus
Ability to develop and maintain data integration/ETL specifications that states integration rules and mappings
Ability to use documentation tools such as MS Visio and MS PowerPoint to diagram integration data flows
Ability to communicate effectively with business and technical staff members
Bachelor’s degree in Computer Engineering, Computer Science, Engineering, or related field of study

Certifications in ETL and Data Warehouse platforms
Domain experience in Healthcare
Data profiling and implementation of automated solutions for data quality checks