We provide IT Staff Augmentation Services!

Etl Developer Resume

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

Hire Now