SUMMARY

• Over 13+ years of experience in Requirements gathering, analysis, Designing, Implementation, Testing, Production support and Resource Management in Data warehousing.
• Good working Experience in Software Development Life Cycle (SDLC) methodologies like Waterfall and Agile.
• Participated in daily stand - ups, weekly grooming sessions, conducting code reviews as well as formal walk through among various teams and documenting the proceedings.
• Experienced in using ETL tools including Informatica PowerCenter 10.x/9.x/8.x/7.x, Informatica Power Exchange.
• Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.
• Data modelling knowledge in Dimensional Data modelling, Star Schema, Snow-Flake Schema, Fact and dimensions tables.
• Performed the data profiling and analysis making use of Informatica.
• Experienced in using advanced concepts of Informatica like Push down Optimization.
• Used Address validator transformation to validate source data with the reference data for standardizes addresses.
• Extracted various data from SalesForce.com using Informatica 10.2 with Salesforce Adapter and also extracted from Web services are based on open standards, such as XML, SOAP, and WSDL
• Experience in using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows and processing tasks using Informatica Designer / Workflow Manager.
• Worked extensively with slowly changing dimensions mappings of Type1, Type2 and Type3.
• Worked with Teradata utilities like Fast Load, Multi Load, T pump and Teradata Parallel transporter.
• Experienced in writing SQL, PL/SQL programming, Stored Procedures, Functions, Triggers, Views and Materialized Views.
• Good command on Database as Oracle, Teradata, SQL Server, Exadata, MS Access and SOQL.
• Extensive experience in writing UNIX and automation of the ETL processes using UNIX.
• Experienced in interacting with Clients, UAT Users and Developers.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Deftly executed multi-resource projects following Onsite Offshore model while serving as a Mentor for the Team Members.
• Good knowledge on Salesforce, SOQL, PostgreSQL and Python.

TECHNICAL SKILLS

ETL Tool: Informatica PowerCenter 10.x/9.x/8.x/7.x, Informatica Power Exchange 10.x/9.x/8.x

RDBMS: Oracle 11g/10g/9i, SQL, PL/SQL, Exadata, Teradata, MS Access, SOQL, PostgreSQL

Languages: Shell script, Batch script, Python

Cloud: Salesforce

Operating System: Windows, UNIX and LINUX

Other Tools: ServiceNow, WynRs, WinSCP, Putty, Okta, PagerDuty, SharePoint, Office 365,SSIS

Methodologies: Waterfall, Agile

Career Profile: Dates

Organization: Designation

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• This project follows an agile Methodology
• Participated in Daily stand-ups, Weekly grooming sessions, conducting code reviews as well as formal walk through among various teams and documenting the proceedings
• Extracted various data from SalesForce.com using Informatica 10.2 with Salesforce Adapter and also extracted from Web services are based on open standards, such as XML, SOAP, and WSDL
• Reading data from Salesforce and loading to salesforce and oracle and flat files
• Used salesforce insert and upsert, max batch size options
• Also used to save the error and success files using the ‘Use Sfdc Error File’ and ‘Use Sfdc Success File’
• Worked on querying Salesforce.com database using SOQL
• Developed Detail Design and Mapping Document to present to client for the Informatica process for the Salesforce objects and WSDL
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Involved in ETL Processes to load data from Flat file, Oracle into target Oracle database by applying business logic.
• Developed Control and Audit Tables by using Business requirements.
• Involved in Data Profiling and Cleansing.
• Maintaining standards (naming convention) and Quality.
• Using designer to create source definitions, design targets, create mappings and develop transformations.
• Created sessions using Informatica PowerCenter server.
• Involved in Unit Testing.
• Documentation of Technical system design, create Unit test cases, Unit test result documents, documenting production migrations and compliance activities.

Environment: Windows 10 Enterprise, UNIX and LINUX, Informatica PowerCenter 10.x, Oracle 11g, Toad 12.9,Salesforce, SOQL and Soap UI

Confidential

Sr. ETL-Developer

Responsibilities:

• This project follows an agile Methodology
• Participated in Daily stand-ups, Weekly grooming sessions, conducting code reviews as well as formal walk through among various teams and documenting the proceedings
• Extracted various data from COBOL files using Informatica 10.2 with Informatica Power exchange and also extracted from Oracle database and flat files
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Involved in ETL Processes to load data from Flat file, Oracle into target Oracle database by applying business logic.
• Developed Control and Audit Tables by using Business requirements.
• Using designer to create source definitions, design targets, create mappings and develop transformations.
• Created sessions using Informatica PowerCenter server.
• Involved in Data Profiling and Cleansing
• Maintaining standards (naming convention) and Quality.
• Documentation of Technical system design, create Unit test cases, Unit test result documents, documenting production migrations and compliance activities.

Environment: Windows 8, UNIX, Informatica PowerCenter 9.x/10.x, Oracle 11g, SQL Developer

Confidential

ETL-Developer

Responsibilities:

• Extracted various data from COBOL files using Informatica 10.2 with Informatica Power exchange and also extracted from Oracle database and flat files
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Involved in ETL Processes to load data from Flat file, Oracle into target Oracle database by applying business logic.
• Developed Control and Audit Tables by using Business requirements.
• Using designer to create source definitions, design targets, create mappings and develop transformations.
• Created sessions using Informatica PowerCenter server.
• Involved in Data Profiling and Cleansing
• Maintaining standards (naming convention) and Quality.
• Documentation of Technical system design, create Unit test cases, Unit test result documents, documenting production migrations and compliance activities.

Environment: Windows 8, UNIX, Informatica PowerCenter 9.x, Oracle 10g, Toad

Confidential

ETL-Developer

Responsibilities:

• Extracted various data from COBOL files using Informatica 10.2 with Informatica Power exchange and also extracted from Oracle database and flat files
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Involved in ETL Processes to load data from Flat file, Oracle into target Oracle database by applying business logic.
• Developed Control and Audit Tables by using Business requirements.
• Using designer to create source definitions, design targets, create mappings and develop transformations.
• Created sessions using Informatica PowerCenter server.
• Involved in Data Profiling and Cleansing
• Maintaining standards (naming convention) and Quality.
• Documentation of Technical system design, create Unit test cases, Unit test result documents, documenting production migrations and compliance activities.

Environment: Windows XP/8, Batch Scripting, Informatica PowerCenter 8.x/9.x, Oracle 10g/9i, SQL Developer