SUMMARY:

• Have 7+ years of experience in Software development industry.
• Deep knowledge on ETL tools like Informatica Power Center, Informatica Data quality tool, Informatica Power Exchange and Informatica Analyst tool
• Extensive skill set in Automating processes to reduce manual efforts.
• Willingness to enhance knowledge on any new technologies.
• Worked on Distributed Hadoop file system, hands on with Hive, Pig and HDFS commands.
• Data profiling using Informatica Analyst tool.
• Good knowledge in handling EBCDIC and flat file system.
• Extensive scripting knowledge of SQL and tuning techniques.
• Have domain expertise in banking projects.
• Expertise in Data Analysis to gather requirements for data warehousing.
• Have expertise in Data Conversion, Data Migration and Data Warehousing projects.
• Possess strong data analytical and problem solving skills.
• Possess excellent business and communication skills, ability to master new skills and Technologies in Faster pace, Dedicated, Hard worker and Good Team player.
• Have a professional attitude and good communication skills, self - motivated and multi-task oriented, with strong work ethic and ability to work effectively.
• Very proactive and took initiative in taking up additional responsibilities in every project worked.
• Programming languages known Unix shell scripting, Java, Excel Macro

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, IDQ, Informatica Analyst

Databases: Oracle 10g, Teradata 13.11, Splice Machine, Hadoop File System

Operating Systems: Windows 10 / 2000 / XP / 2003, LINUX

Front End Tools: TOAD, SQL Plus, SQL Developer, Teradata SQL Assistant

Programming Languages: Java, PL/SQL, Unix Shell Scripting, Excel Macro

Scheduling Tools: Control M, Autosys

S/W development Methodologies: Agile, Waterfall models

STRENGTHS:

• Technically very strong and provides sound technical support to the team to resolve critical problems.
• Unique ability to quickly adapt to changing scenarios and effectively manage deliverables accordingly.
• Willingness to enhance knowledge on any new technologies.
• Very strong Analytical, Problem solving and Interpersonal skills with very good communication skills. Willingness to listen to new ideas, or to adopt alternative approaches
• Teamwork and collaboration
• Focus on reusability, customer satisfaction and value-add.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Senior ETL Lead

Tools: Informatica Power Center 9.6, Oracle 9i, SVN, Autosys, Hadoop, Splice Machine

Scripting: UNIX scripting, Java, Macro

Responsibilities:

• Working as a Senior ETL Lead for onsite/offshore model and leading a team of 9 members.
• Gathering requirements from the Business analysts and transferring the requirements to the offshore team
• Technical consultant for the team to provide optimal solutions, design reviews, code reviews and for any issues.
• Provides solutions on architectural needs as part of design meetings.
• Workings on POC for bringing new technologies like Splice machine and Spark with Hadoop.
• Conformed Layer data flow planning and decisions.
• Updates the status of development to client managers on day to day basis.
• Manage offshore team to get the required output without breaking the timelines.
• Automation initiatives for entire project development to reduce repetitive work and increase productivity
• Informatica Administrator usage for monitoring job runs and analyzing session logs.
• Involved in all phases of development starting from Requirements Analysis, Data profiling, High level design, Low level design, Coding, Testing and UAT and Implementation.
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Conducted design and review meetings to get design approval from different stake holders in the project.
• Involved in planning, effort tracking and estimations for the project.
• Fine-tuned the mappings using push down optimization, session partitioning, bulk load, fast load, etc.
• Supported System Testing and UAT.

Confidential, Saint Louis, MO

Senior ETL Lead

Tools: Informatica Power Center 9.6, Informatica IDQ, Informatica Analyst, Oracle 9i, Hadoop File System, Autosys

Scripting: UNIX scripting

Responsibilities:

• Working as a Senior ETL Lead for onsite/offshore model and leading a team of 5 members.
• Key player in requirement gathering and estimating timeline for the development life cycle.
• Technical consultant for the team to provide optimal solutions, design reviews, code reviews and for any issues.
• Developed several reusable components during the course of the Project which considerably reduced the unit testing effort and data capturing issues.
• Created IDQ Mappings for ETL processing of data from RAW layer, HM layer and Consumer Layers.
• Used Informatica Analyst tool to do Data profiling to understand the business requirements.
• Created shell script to automate unit testing inside Hadoop file system
• Automated data loading technique from Hadoop fixed with files to Oracle tables.
• Informatica Administrator usage for monitoring job runs and analyzing session logs.
• Providing inputs to project stake holders and data Architects to accomplish the design of the project.
• Involved in all phases of development starting from Requirements Analysis, Data profiling, High level design, Low level design, Coding, Testing and UAT and Implementation.
• Mentored team on Informatica and data modeling concepts.
• Involved in planning, effort tracking and estimations for the project.
• Worked on updating system Architecture flow and Data modeling.

Confidential, Dublin, OH

Senior ETL Lead

Tools: Informatica Power Center 9.5.1,Informatica Power Exchange, Teradata 13.11, Oracle 9i, SVN tool, Control M

Scripting: UNIX scripting

Responsibilities:

• Working as a Senior ETL Lead for onsite/offshore model and leading a team of 12 members.
• Key Player in the team, assigned with designing, extracts/mappings having millions of data and complex logics.
• Technical consultant for the team to provide optimal solutions, design reviews, code reviews and for any Informatica related issues.
• Developed several reusable components during the course of the Project which considerably reduced the development effort.
• Created mappings, mapplets, reusable transformations, sessions and workflows in Informatica. Also used several transformations like expression, Aggregator, Lookups, Joiner, Normalizer, Router, update strategy, Filter, Union, Sequence Generator, Stored Procedure, Source qualifier, XML transformation, pre SQL, post SQL, etc.
• Created mappings to import data from heterogeneous sources like VSAM files, XML files and delimited flat files.
• Developed stored procedures to implement business logic.
• Fine-tuned the mappings using push down optimization, session partitioning, bulk load, fast load, etc.
• Worked with parameter files and also created parameter values across mappings.
• Used Informatica Workflow Manager, Workflow monitor and repository manager.
• Responsible to work with project stake holders, Data Architects and Data Definition Owners in different subject areas.
• Involved in all phases of development starting from Requirements Analysis, Data profiling, Data, High level design, Low level design, Coding, performance tuning, and Testing, Supported System Testing and UAT and Implementation.
• Involved in Data profiling and performed data analysis according to the mapping/transformation rules, which helped in catching many Sourcing Issues upfront.
• Translated business needs into data models supporting long-term solutions.
• Worked with the Application Development team to implement data strategies, build data flows and developed conceptual data models.

Confidential

Team Lead

Tools: Informatica Power Center 8x and 9.5.1, Informatica PowerExchage, Oracle 9i, SVN tool, Control M

Scripting: UNIX scripting, PLSQL Programming

Responsibilities:

• Worked as a Team Lead of Bug Fix team at offshore with a team size of five members.
• Handled multiple PROD issues and provided quick resolution to meet SLA’s.
• Worked with PROD Support team to ensure smooth migrations.
• Enhancement of Confidential treasury TDH/EDW model, involved in all phases of development starting from Requirements Analysis, high level design, low level design, Coding, and Testing, Supported System Testing and UAT and Implementation.
• Conducted design and review meetings to get design approval from different stake holders in the project.
• Mentored team on Informatica and data modeling concepts.
• Developed logic for MDM business data load to DWH.
• Involved in data analysis and production bug fixings.
• Translated business needs into codes supporting long-term solutions.
• Developed best practices for standard naming conventions and coding practices.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging and Data Warehouse.
• Handled critical projects with frequently changing requirements and provided fast turn around results.
• Review the documentation and coding created by other team members.
• Developed Informatica mappings to load the data from files to Oracle data base and Teradata to Oracle data bases.
• Developed sophisticated design which helped to enhance the business needs in the change requests with minimal enhancements to the design.

Confidential

ETL Developer

Tools: Informatica Power Center 8x, Oracle 8i, SQL

Scripting: UNIX scripting

Responsibilities:

• Worked as ETL Developer for Onsite/offshore model at offshore.
• Involved in preparing technical design specification, coding and testing. Involved in peer code reviews.
• Responsible in getting all the requirements from onsite coordinator and analyzed all the requirements without any gaps.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging and Data Warehouse.
• Designed the Mapping Technical Specifications on the basis of Functional Requirements.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines Sequence generator etc transformations in the mappings.
• Used SQL tools like SQL Developer to run SQL queries and validate the data loaded into the target tables.
• Review the documentation and coding created by other team members.
• Developed standards document, Coding check list which helped the team to avoid defects in the early stage.
• Mentored new team members who joined the team on functional, technical and process aspects and data modeling concepts.
• Developed stored procedures to implement business logic.
• Handled critical projects with frequently changing requirements and provided fast turn-around results.

Confidential

Team member

Tools: Informatica Power Center 8.5.1, Oracle 8i, Flat files

Scripting: UNIX scripting, PLSQL Programming

Responsibilities:

• Monitored Workflow Monitor, Workflow Manager and Designer.
• Understanding the Error which is a cause to fail ETL batches and find a solution to complete batches successfully which are daily, weekly, monthly, quarterly and yearly.
• Checking files in Unix directories which has been placed or not.
• Handled Complexity issues and resolved them in time.
• Communicated with clients for giving smooth supporting to the business.
• Handled Critical Supporting Activities which were quarterly and yearly.
• Prepared RCA (Root Cause analysis) documents.
• Changed the existing code according to the business requirements.
• Handled QA reviews are cutover activities very well.
• Delivered quality code with minimal defects which was highly appreciated by the client.