ETL Developer (team member) Resume

SUMMARY:

Seeking a challenging position in a reputed organization where I can utilize my skills aptly and ensure continuous learning and self - development.
9+ years of experience in software analysis, design and development for various software applications in client-server environment with expertise in providing ETL solutions in Data Warehousing for Decision Support Systems.
Last Associated with Amdocs DVCI Pune as Development Specialist.
Played a role of Data Architect on last project Confidential Confidential.
Experienced in Extract Transform and Load (ETL) using Snowflake (certified professional), Informatica PowerCenter 9.x/8.x/7.x/6.x, Informatica Client Tools, Teradata etc.
Experienced working with wide range of data sources such as Snowflake, Teradata, Oracle, MySQL, Flat Files, VSAM, Cobol files etc.
Industrial knowledge of Big Data technologies like HDFS, Hive, Sqoop.
Experienced in dealing with stakeholders spread across globe on daily basis to scope, plan, design, deliver and maintain the solutions to address the mission critical problems.
Experienced in Unix Shell Scripts & Teradata Scripts (TPT, Mload, Tpump, Bteq).
Having extensive experience in designing Unit testing, Integration testing and User acceptance testing strategy and performing it.
Having extensive experience in documenting the project and mentored developers by providing technical guidance and troubleshooting assistance.
Innovative in approach, enjoys adapting new methodologies and ideas, putting them into daily practice
Team player with effective communication skills and proven abilities in resolving complex issues.

TECHNICAL SKILLS:

Databases: Snowflake, Teradata, Oracle, MySQL, SQL Server

Languages: SQL, PL/SQL, UNIX Shell Script, Java

Application Tools: Informatica Power Center 9.X,8.X

Operating Systems: UNIX, Windows 9x/2000/XP/NT

Database Tools: Teradata SQL Assistance, Toad

Tools: /Utilities: TWS8.2/8.5, Quality Center, Maestro Scheduling Tool, Rally

FUNCTIONAL:

Designing the complete model & finalizing the flow for developing new processes.
Delivering the Project & milestones as per timelines. Participating in Customer meetings, Onsite Deployments, System Integration and Process Up-gradation.
Interacting with client for Requirement gathering, analysis, implementation of the process.
Implementing the development on Agile Methodology.
Implementing Performance tuning techniques in existing processes.
Working & developing E2E data warehouse architecture, having various types of Schemas and dimension tables.

PROFESSIONAL EXPERIENCE:

Confidential

Platform: Windows7

Software: Teradata, Informatica 8.x, Unix, TWS

ETL Developer (team member)

Responsibilities:

To gather requirement and interact with the client for the same.
To mentor the new joinees and help them to understand the project and work in better way.
To develop code as per business requirement.
To perform major role in understanding the business requirements and designing and loading the data into DataMart (ETL).
To develop mappings in Informatica to load the data from various sources into the Data Warehouse using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
To create Sessions, Workflows, writing the unit test conditions and involved in performing unit testing.
To implement performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
To develop create Teradata utilities and Shell scripts to load data into DataMart as well as to perform calculations based on business logic
To package of the developed component to be deployed in production environment.
To take part in project documentation.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship