Send me more jobs like this

ETL Data Integration Architect

Keywords / Skills : modeling data integration architecture , data integration roadmap , data Warehousing , ETL , Data Models , Informatica , SSIS , AWS , PL/SQL , Unix Shell Scripts , Python , SQL , SDLC , BI Projects , Oracle , T-SQL

5 - 7 years
Posted: 2019-08-14

Industry
IT/Computers - Software
Function
IT
Role
Software Engineer/ Programmer
Posted On
14th Aug 2019
Job Ref code
10244
Job Description
Job Descriptions:

Role Purpose
  • Responsible for defining and modeling data integration architecture needs and impacts.
  • Provides data integration roadmap for interconnectivity of systems and provides remediation plans for possible data inconsistencies.
  • Overseeing all aspects of DWH and ETL. This includes alignment to best practices for both storage and integration design principles facilitating optimized implementation, administration, and monitoring.

Main Duties and Responsibilities
  • Primary responsibility to work with Enterprise Information Systems teams to maintain and develop data integration solutions to support our Analytics platform.
  • Work closely with Business Analysts and help them in business requirement document completion.
  • Understand business requirements and convert them into detail technical specifications for ETL programs and Data models.
  • The solutions must align with EDW and dimensional modeling, ETL standards and guidelines.
  • Design and develop ETL programs using contemporary ETL toolsets (Informatica, Talend, SSIS, AWS Glue etc), PL/SQL, Unix Shell Scripts, and Python.
  • Performance improvement & tuning of data mappings, SQL & PL/SQL scripts
  • Technical reviews, data validation & end-to-end testing of ETL Objects, source data analysis and data profiling.
  • Create necessary documentation as per SDLC standards.
  • Maintain code version control.
  • Plan and participate in end-to-end testing.
  • Provide daily/weekly project status to the project manager.
  • Work with deployment team in code migration tasks across SDLC environments.
  • Triage the production issues and work on the code fixes.
  • Experience with ETL toolset monitoring, configuration, administration and security setup.
  • Coach and guide managed services team in terms of deployment of ETL jobs, and post production support.
  • Handle multiple projects in parallel.

Skills:
  • 5+ years of experience in implementation of DWH/BI projects in large scale MPP data warehouse environments: Teradata, Greenplum, Netezza, Vertica or a variation.
  • 5+ years of hands on experience in ETL tool architecture and products (Informatica, Talend, SSIS, AWS Glue etc).
  • 5+ years of hands on experience with programming technologies (Python, Unix shell script, Perl etc).
  • 5+ years of converting functional specifications into ETL technical specifications.
  • 2+ years of hands on experience in reporting tools like Tableau, Cognos, etc
  • Knowledge of end-to-end SDLC process in DWH/BI projects.
  • Dimensional modelling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts etc.
  • Hands on experience with database like Oracle, MSSQL Server and database languages like SQL, PL/SQL and T-SQL.
  • Strong SQL, PL/SQL tuning & performance improvement skills.
  • Excellent understanding of data quality concepts




Similar Jobs
View All Similar Jobs
Walkin for you