Data Engineer Resume

SUMMARY

Around 7+ years of experience in ETL, Data warehousing and Business Intelligence applications using Informatica and Talend Big Data Integration
Experience in Integrating Talend with Google Big Query, Google Cloud Storage, Hadoop, Hive, MySQL, Snowflake and Salesforce.
Experience in interacting with Business Users to analyze the process and transforming requirements into performing ETL and deliver the deliverables.
Expertise in Extraction, loading and transformation from APIs, Flat files and XML using Talend Big Data Integration.
Experience working with Data Warehousing Concepts like OLAP, OLTP, Star Schema and Snowflake Schema
Expertise on Exception Handling for Data Quality, Data cleansing and Data Validation.
Experience in tuning the performance for Complex queries.

TECHNICAL SKILLS

ETL Technologies: Informatica Power Center, Talend Big Data Integration

Databases: MSSQL, MySQL, Oracle, Google Big Query, Snowflake and Hive

Languages: Core Java, Python, JavaScript, ExtJS, ASP and HTML

Hadoop Technologies: Cloudera, Map reduce and Spark

Modelling Methodology: NoSQL, OLAP

PROFESSIONAL EXPERIENCE

Confidential

Data Engineer

Environment: Windows, Linux

Responsibilities:

Analyzing the requirements and developing a design document
Discussing the requirements with client and verifying the design with a client.
Implementing the changes in design as well as code as per the requirements.
Worked on Migration projects to migrate data from Hadoop to Snowflake and Google Big Query.
Responsible to tune ETL mappings and complex queries.
Developed ETL jobs to get data from REST and SOAP APIs, load it into Big Query and Snowflake.
Worked on Exception Handling for Data quality and Data validation.
Perform the unit testing and Integration testing
Coordinating for Customer Acceptance Testing
Coordinating for Production release and deploy the changes to server.
Monitored and supported the Talend jobs scheduled through Talend Admin Center (TAC).

Confidential

ETL Developer

Environment: Windows

Responsibilities:

Analyzing the requirements and developing a design document.
Implementing the changes in design as well as code as per the requirements.
Worked on Migration projects to migrate data from SQL Server/Oracle to Google Big Query and Sales force to Big Query.
Developed ETL Pipeline to get data from Flat files to RDBMS.
Perform the unit testing and Integration testing
Coordinating for Customer Acceptance Testing
Coordinating for Production release and deploy the changes to server.
Monitored and supported the Talend jobs scheduled through Talend Admin Center (TAC).

Confidential

Developer

Environment: Windows

Responsibilities:

Analyzing the requirements and developing a design document
Discussing the requirements with client and verifying the design with a client.
Implementing the changes in design as well as code as per the requirements.
Worked on integrating processes with Enterprise Data warehouse.
Responsible to tune ETL mappings, Workflows, and underlying data model to optimize load and query Performance.
Perform the unit testing and Integration testing
Coordinating for Customer Acceptance Testing
Coordinating for Production release and deploy the changes to server.
Worked on creating Dashboards in OBIEE