Principal Responsibilities:

Analyze data requirements, complex source data and the data models to determine the best methods for extracting, transforming and loading the data into the warehouse
Design and implement processes that transform data for the Enterprise Data Warehouse according to business needs. This may include views, ETL and ELT processes that manipulate, aggregate, clean, or enrich the data
Provide technical assistance in identifying, evaluating, and developing systems and procedures
Manage data administration tasks such as scheduling jobs and troubleshooting job errors
Effectively communicate status, workloads, offers to assist other areas
Participate in design and implementation review sessions and ensure all solutions are aligned to pre-defined architectural specifications
Productionize the ETL changes by going through the review and approval processes by interfacing with different teams like engineering, operations and DBAs
Interface with the business team and business analysts, support QA & UAT Testing, deployment, and Level 3 support for Data & ETL

Experience:

Minimum of 8 years experience in ETL Data Integration, system analysis and Data Warehousing

Possess a thorough understanding of the software implementation lifecycle (SILC) and Agile development
Demonstrates advanced analytical skills for complex data structures and big data.
Possesses strong experience with major commercial ETL tools (DataStage, Talend)
Strong understanding of data warehouse concepts and architecture. Understanding of star/snowflake schema design; dimension and fact tables
Experience is writing complex SQL and PL SQL for data processing and reporting environments.
Experience in data modeling and data architecture (logical and physical) for a Data Warehouse environment
Expert in overall ETL Data Integration Architecture for very large, high volume transaction Data Warehouses with near -real time analytical requirements
Experience with high-scale distributed MPP databases such as Greenplum and standard RDBMS systems (PostgreSQL, Oracle, Sybase, SQL Server) and cloud warehouse like Snowflake
5+ years of experience working with Unix / Linux Shell Scripts
Experience working with public cloud like AWS or Azure
Experience in CI/CD and working knowledge of Jenkins, Bitbucket, JIRA
Strong written and verbal communication skills: including both with technical peers as well as business partners

The recruiter working on this position is Naga Lakshmi
His/her contact number is
His/her contact email is lakshmi@msysinc.com

Our recruiters will be more than happy to help you to get this contract.