SUMMARY

• Around 7 Years of IT industry experience encompassing a range of skill set and roles.
• Worked in Data Warehousing, this includes IBM InfoSphere (Data Stage ver. 8.1, 11.3) & Databases (‘Teradata', ‘Oracle’, ‘Hive’) & Streaming Framework and Tools.
• Extensive experience in Entire Life Cycle of teh projects. Involved in different phases of SDLC like Analysis, Design, Development, Implementation, Testing and Support for variety of ETL related tasks on Data warehouses and Interfaces.
• Worked in Informatica to Datastage migratin project.
• Handled deliverables end to end (Requirement Analysis to Deployment) wifout any support.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema) and other DataWarehousing Concepts.
• Worked in both Waterfall and Agile model projects.
• Ability to quickly adapt to changing priorities, requests, and environments.
• Strong communication, reasoning, analytical, and organizational skills.
• Worked on basic hadoop development projects using Hive (External and Internal Tables), HDFS, NIFI, and HBASE.
• Worked in data streaming projects to consume data in Kafka using python scripts and NIFI.
• Worked on Python script for modifying bulk DataStage jobs from backend to accommodate changing datamodel standards.
• Worked in dev - ops model where we supported production environment for our products on rotation basis along wif other development deliverables.
• Worked in different scheduling tools like Autosys, TWS, and Airflow.

TECHNICAL SKILLS

ETL Tool: DataStage 11.3/8.1

Databases: Oracle, Teradata, Hive, HBASE

Scheduling Tool: Autosys, TWS, Airflow

Languages: SQL, PL/SQL, Python Basics

DataFlow Tools: NIFI

Streaming Framework: Kafka

Operating System Windows: NT/ 95/98/2000/10, Unix

Version control tools: GitHub, Gitlab, Rational Team Concert

Implementation tools: Service Now, SERENA

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL/ Data stage Developer

Responsibilities:

• Working in dev-ops model to support all teh roles in lifecycle from Analysis to Production support on rotation basis.
• Data Analysis for production issues and applying teh code fixes.
• Understanding teh changes in upstream data for accommodating teh changes in acquisition and integration.
• Analyzing, modifying and writing SQLs.
• Effective communications wif business partners for gathering requirements and implementing them.
• To work on innovative projects to minimize teh pain points in teh life cycle like impact analysis tools.
• Understanding, implementing and improving teh existing process for effective data management (Like reconciliation process for finance data to avoid amount mismatches across sources).
• Supporting teh junior team members.
• Incorporating teh new technologies wif teh changing needs in teh data warehouse industry (Like Streaming process, Airflow).
• Developing generic processes which can be reused for similar purposes across multiple projects.

Confidential

ETL/Data stage Developer

Responsibilities:

• Worked in development of project which involves sending extract from EDW to other team about teh Hardship suspension period of participant to send appropriate reminder mails to participants.
• Worked in building a table which has marketing details to halp java team to create microsites for flexible approach of getting information to participants and clients.
• Worked on NIFI based project for streaming teh messages which are pushed into KAFKA brokers and writing into HBASE and tan to Hive Databases.
• As part of TRUST Replatform project, where teh data in our data warehouse should be loaded from new TRUST platform instead of legacy platform, handled teh related unseen business issues.
• Contributed to innovation items and worked on python script to modify datastage jobs from backend.
• Analyzing initial requirements and provide estimates to teh client.
• Participating in Analysis and Design Discussions.
• Development and testing of datastage jobs which include reading from hive.
• Handling and supporting all teh involved teams (Business and Users) in a project alone.
• Involving in developing teh data loading and extraction processes for big data analysis.
• Imported data from Teradata and Oracle to HDFS using SQOOP.
• Writing Hive queries to load and process data in Hadoop File System.
• Creating Hive tables to store teh processed results in a tabular format.
• Creating a generic process to create Autosys jills for a generic file load process.

Confidential

Datastage Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection by working wif business analysts and business users.
• Preparing mapping documents and designing teh jobs based on teh requirements.
• Implementing Industry ETL standards and standard practices, performance tuning during designing teh Datastage Jobs.
• Developing and unit testing teh code.
• Writing complex SQL queries to extract teh data and to test teh functionality of teh developed code.
• Migrating teh code to higher environments using RTC and SERENA tools.
• Writing autosys jills for scheduling teh jobs.
• Providing Support to QA testing teams and to Production teams for initial runs in teh production environment.
• Defect Management and achieving zero defect migration.
• Worked in creating generic process to stage files in teh system which comes from vendors.
• Creating Analysis, Design, Testing Documents. Involved in designing data models.
• Helping teh new joiners in teh team wif project needs and providing required knowledge transition by having workshops.
• Developed Parallel jobs using Parallel stages like: Dataset, Sequential file, Funnel, Filter, Join, Lookup, Transformer, Aggregator, Remove Duplicates, CDC, pivot, XML and database connectors.
• Worked in Informatica to Datastage migration project.
• Built jobs for many extracts that halps in marketing and analysis.