• Job ID:

  J53282

• Job Title:

  Data Engineer

• Location:

  San Jose, CA

• Duration:

  6 Months + Extension

• Domain Exposure:

  Pharmaceuticals

• Work Authorization:

  US Citizen,Green Card,OPT-EAD,CPT,H-1B,H4-EAD,L2-EAD,GC-EAD

• Client:

  To Be Discussed Later

• Employment Type:

  W-2, 1099, C2C

Role: Data Engineer

Technology Stack: Python, SQL, PySpark, Apache Spark, Azure Data Factory, Databricks, Azure Data Lake, AWS, Snowflake, ETL/ELT, SQL Server, Power BI, Git.

Roles and Responsibilities

• Designed, developed, and maintained scalable data pipelines to extract, transform, and load data from multiple sources.

• Developed ETL/ELT workflows using Python, SQL, PySpark, and Azure Data Factory.

• Built and optimized data processing solutions using Apache Spark and Databricks.

• Worked with structured and unstructured data from relational databases, APIs, flat files, and cloud storage.

• Designed and implemented data integration solutions to support business intelligence and analytics requirements.

• Developed complex SQL queries, stored procedures, views, and functions to transform and process large datasets.

• Implemented data validation, data cleansing, data transformation, and data quality checks to ensure data accuracy.

• Worked with Azure Data Lake Storage and cloud-based data platforms to store and manage large volumes of data.

• Created and maintained data warehouses, data marts, and dimensional data models.

• Integrated data from multiple enterprise systems using REST APIs and database connectors.

• Monitored data pipelines, identified failures, and resolved performance and data processing issues.

• Implemented incremental data loading, partitioning, and optimization techniques to improve pipeline performance.

• Worked with Snowflake for data loading, transformation, query optimization, and warehouse management.

• Implemented data security, access controls, and governance practices to protect sensitive business information.

• Used Git and Azure DevOps for source control, CI/CD, and deployment management.

• Collaborated with data analysts, data scientists, and business teams to understand data requirements.

• Participated in Agile/Scrum ceremonies, technical discussions, code reviews, and production support.

Technical Skills

• Programming: Python, SQL, PySpark

• Big Data: Apache Spark, Hadoop, Databricks

• ETL Tools: Azure Data Factory, Informatica, SSIS

• Cloud Platforms: Microsoft Azure, AWS

• Data Storage: Azure Data Lake, Amazon S3

• Data Warehousing: Snowflake, Azure Synapse Analytics, SQL Server

• Databases: PostgreSQL, MySQL, Oracle, SQL Server

• Data Modeling: Star Schema, Snowflake Schema, Dimensional Modeling

• DevOps: Git, Azure DevOps, CI/CD, Jenkins

• Reporting: Power BI

• Methodologies: Agile, Scrum, SDLC

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.

• Experience in data engineering, ETL development, and data pipeline implementation.

• Strong programming knowledge in Python, SQL, and PySpark.

• Experience working with cloud platforms and data warehousing technologies.

• Understanding of data modeling, database concepts, and data integration.

• Strong analytical, problem-solving, debugging, and communication skills.

Equal Opportunity Employer

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.