Title: Data Engineer

Employment Type: C2C.

Visa: H1-B, USC, H4EAD, TN.

Location: - Phoenix/AZ -Onsite 

ONLY EX- AMEX Experience 

Skills: Data Analytics, MS SQL, MS SQL (SSIS, SSRS) Pyspark, python, ETL-Big Data/Data warehousing/Oracle PL/SQL, Big Data, Apptio

JD:

• Individual contributor to an SDLC life cycle based agile team
• Hands on proficiency and expert-level knowledge in at least one object oriented programming language in C, C++ Or Java
• Deep knowledge in RDBMS concepts and data engineering as a concept and service (data warehousing, data lakes and master data management)
• Expert at analyzing and developing queries in SQL in various dialects (SQL Server, DB2, Oracle)
• Hands on experience in manipulating databases via DML code packages, stored procedures, triggers and materialized views
• Hands on experience in developing reports and dashboards using tools such as Qlik, Tableau or Power BI
• Hands on experience in integrating two systems to process data through various channels (SOAP, Rest, ETL and SSIS)
• Hands on experience with Node Js and JSON
• Familiarity with Airflow and understands how to develop DAGs
• Familiarity with Spark is plus
• Willing to learn new cloud based business apps and tools
• Capable of devising ETL pipelines using Python from scratch
• Ability to independently write efficient and reusable code for ETL pipelines
• Expert in data modeling concepts such as schemas and entity relationships