Data Analyst, ETL Tech Lead Resume Atlanta, GA - Hire IT People

SUMMARY:

6+ years of IT industry experience encompassing a wide range of skill sets working in Data analytics and Data integration fields.
Skillset includes ETL, HIVE, Hadoop, Python, Spark, SQL, Unix scripting, Data warehousing.
Experience with analysis, design, development and implementation of banking applications.
Searching for opportunity to bring 6+ years of data engineering experience to efficiently contribute to the company’s growth and to grow in big data technologies, cloud platforms and data science.

TECHNICAL SKILLS:

SKILLS: Informatica 9/10, Ab Initio 3.3 Oracle SQL C++ Unix Scripting Control M Scheduling, CA7 Scheduling Hadoop, Hive Cognos, Tableu

WORK EXPERIENCE:

Confidential, Atlanta, GA

Data Analyst, ETL Tech Lead

Responsibilities:

Validating the data lineages using Meta data hub and EME dependencies.
Performance improvement of the ETL process by using resource pool.
Worked on Meta programming, Dependency analysis, PDL, Meta hub data lineage, control center.
Creation of the UNIX scripts to further accommodate the client requirement to manage the data controls.
Loading the data to Oracle tables and DB2 tables.
Using the Hadoop distributed file systems to load data using partitions into HIVE partitions.
Analyze the data loaded into Distributed systems using Interface like Hue.
Led the technical team both onsite and offshore in order to meet task deliverables.
Understanding the business requirements to use data source applications like ALS, ACAPS for designing the ETL process building different Abinitio Graphs .
Implement the ETL process for these SunTrust's consumer applications based on the design using Data Lake architecture.

Confidential, Pune, Maharashtra

Senior ETL Developer - Abinitio

Responsibilities:

Graph Enhancements using PDL and maintaining the version of EME objects.
Creation of the PSET s for generic object.
Dependency analysis (DA) for PSET created.
End to end testing(Manual) of graphs created based on the ETL process dependencies.
Developing test case documents for the unit testing.
Testing overall process by automated scheduling using control M scheduler in all environment.
Data validation using development and production data comparison
Modification of existing ETL graphs based on LLD design migration points.

Confidential

ETL Developer-Abinitio

Responsibilities:

Generating load ready files and validate the results against the target data format.
Involved in end to end data validation by interacting with the business users (UAT).
Loading the data into appliance database like DB2 using ETL load utilities.
Defect handling by backtracking the ETL process using Ab>Initio.
Creating generic shell scripts to add data quality checks.
Preparing or updating high/low level documents, mapping documents as per client requirements for any enhancement/defect.
Apply the transformation rules defined by various transform components using mapping documents using Graphs .