This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
We are currently seeking a Software Development Advisor to join our team in Canton, Massachusetts (US-MA), United States (US).
Job Responsibility:
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
Requirements:
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
Nice to have:
Certifications in ETL and Data Warehouse platforms
Domain experience in Healthcare
Data profiling and implementation of automated solutions for data quality checks