Data Engineer C2C jobs with SQL / Stored Procedures at McKinney TX (Day One Onsite)

Data Engineer with SQL / Stored Procedures

Location: McKinney TX (Day One Onsite) Need to Go F2F for 2 Round

Job Type: Contract

Job Description:

Primary Skills: SQL/ Stored Procedures (need to be strong), AWS Redshift, Python/PySpark, Airflow

Secondary Skills: IICS

Functional skills: Hands on knowledge about DW design.

JD:

•             ETL/Data warehousing experience of a minimum of 10 years.

•             Understanding the overall Architecture of the system and ensure the deliverables are in-line with the proposed architecture. Strong in-depth knowledge of RDBMS and SQL.

•             Understand source, target data models, and Develop AWS Glue ETL Pipelines using PySpark.

•             Develop Stored Procedures focusing development of reusable components.

Analyze data processing requirements, source data, and target data models to develop complex SQL queries for data consumption by downstream applications.

Unit Testing and Unit Test Log preparation

Provide QA /UAT/Warranty Support in co-ordination and resolution of observations and defects raised in QA/UAT/Prod

•             Understanding and implementing DMS jobs.

•             Develop components and reusable assets using other AWS Services as applicable like DMS, Lambda, S3, CloudFormation, Airflow.

•             Develop components and reusable assets using IICS in Data integration/Data Warehousing landscape (Secondary skills, nice to have)