We provide IT Staff Augmentation Services!

Etl Developer Resume

2.00/5 (Submit Your Rating)

Cincinnati, OH

PROFESSIONAL SUMMARY:

  • Over 10 years of experience in Information Technology and more than 8 years of experience using ETL Informatica Power Center 10/9.x/8.x
  • Expertise includes Data Analysis, Data Modeling, Data Cleansing, and Transformation, Integration, Data import, Data export and use of ETL tool including Informatica.
  • Extensively worked on Informatica Designer Component’s Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
  • Extensively worked on Informatica Power Center Mappings / Mapplets using various Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
  • Proficient in developing Slowly Changing Dimension Mappings of type I, II and type III.
  • Highly experienced in developing mappings using Parameters and Variables. Extensively used parameter file to pass mapping and session variables.
  • Extensively involved in Informatica performance tuning, error handling, debugging and problem fixing in Informatica.
  • Proficient in warehouse designs based on Ralph Kimball and Bill Inmon methodologies.
  • Significant experience in Dimensional Data Modeling techniques using Star Schema and Snowflake schema with FACT and Dimensions tables designed using ERWIN data modeler.
  • Experience in scheduling of ETL jobs using Autosys, Control - M.
  • Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
  • Excellent exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
  • Extensive Database experience using Oracle 12c/11g/10g/9i/8i, DB2, Sybase, MS SQL Server.
  • Expertise in SQL/PLSQL, T-SQL programming development and execution of packages, stored procedures, functions, triggers.
  • Excellent knowledge of UNIX shell scripting, automation of ETL process and scheduling of jobs.
  • Extensive experience in unit testing, System testing and User Acceptance Testing.
  • Excellent Experience working with offshore and onsite co-ordination.
  • Extensive domain knowledge in Financial / banking / and insurance
  • Proven problem solving skills with excellent analytical, communication and interpersonal skills.
  • Team player, motivated and dynamic with excellent oral and written communication skills.

TECHNICAL SKILLS:

  • Informatica PowerCenter 10/9.x/8.x (Source Analyzer
  • Data Warehouse Designer
  • Mapping Designer
  • Mapplet
  • Transformations
  • Workflow Monitor
  • Worklets)
  • Power Exchange 8.x
  • Oracle 12c/11g/10g/9i/8i
  • SQL Server 2008/2005
  • IBM DB2 UDB 8.1/7.0
  • Sybase
  • SQL
  • PL/SQL
  • T-SQL
  • SQL-Loader
  • Rapid SQL 8.1/7.x
  • SQL-Developer
  • Teradata V2R5/V2R6
  • ERWIN 7.0/5.1/4.1
  • Autosys R11/4.5
  • CronTab/unix
  • OBIEE 11g/10 g
  • Business Objects XI
  • SSIS
  • MYSQL
  • C
  • C++
  • JAVA
  • HTML
  • XML
  • QC 10
  • Windows 2008/2003/2000 Server
  • Sun Solaris 8/9/10
  • Linux
  • IBM AIX 4.3
  • Packages SQL* PLUS
  • Toad 11.5/9.7/8.6
  • Perl Script.

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

ETL Developer

Responsibilities:

  • Analyzed the business requirements and suggested changes to the design accordingly.
  • Facilitate information gathering sessions and provides data analysis and data mapping.
  • Works with Project team to convert from Mainframe ETL processing to open systems ETL processing.
  • Involved in the full life cycle development of the project including design, development, and testing.
  • Loaded the data to target database and Flat files by using target lookup.
  • Identifies data sources, develop and maintain data architectures, constructs data catalog and data decomposition diagrams, provide data flow diagrams and documents the process.
  • Implemented code using various Informatica Transformations like Joiner, Expression, Lookup, Aggregator, Router, etc.
  • Created Informatica deployment groups in repository manager and migrated to different environments.
  • Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
  • Database development including designing, coding, testing and implementing SQL/PL.
  • Involved in creating Mappings using Mapping and Session Parameters in the mappings and workflows to eliminate hard coding wherever possible.
  • Extensively worked with Slowly Changing Dimensions Type1, Type2.
  • Used debugger in the Mapping Designer to troubleshoot logical errors.
  • Facilitate the development of data integration efforts with the development team in addition to hands on design and development of large complex ETL jobs.
  • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
  • Extensively used Informatica Power Center 10 to extract data from various sources, which included Flat files, VSAM, Sql server, Oracle.
  • Extensively used Informatica Client tools - Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Lookup, Update Strategy, Joiner, and Union
  • Involved in creation of various UNIX scripts which help the ETL scheduling jobs and help in initial validations of various tasks.

Environment: MS SQL Server 2016, Informatica Power Center 10, UNIX, UC4, Mainframes, Toad, Oracle, PL/SQL, DB2, Windows Server 2008.

Confidential, Milwaukee, WI

ETL developer

Responsibilities:

  • Actively interacted with the Business Analysts and Business Users to gather, verify and validate various Business Requirements.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
  • Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports, which take longer, time in execution with SQL Server 2008.
  • Created SSIS packages for File Transfer from one location to the other using FTP task.
  • Exposure to Informatica B2B Data Exchange that allows to support the expanding diversity of customers and partners and their data with capabilities that surpass the usual B2B solutions
  • Worked with the B2B Operation console to create the partners, configure the Partner management, Event Monitors and the Events.
  • Exposure to Informatica B2B Data Transformation that supports transformation of structured, unstructured, and semi-structured data types while complying with the multiple standards which govern the data formats.
  • Database development including coding, testing and implementing SQL/PL code
  • Used Data Transformation Studio to transform unstructured to structured forms
  • Used major components like Serializers, Parsers, Mappers and Streamers in Data Transformation Studio for conversion of XML files to other formats.
  • Extensively used Informatica Power Center 9.6 to extract data from various sources, which included Flat files, Sqlserver, Oracle, Ms-Access and XML.
  • Extensively used Informatica Client tools - Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner, and Union
  • Developed ETL mappings industry healthcare standards.
  • Involved in creating Mappings using Mapping and Session Parameters in the mappings and workflows to eliminate hard coding wherever possible.

Environment: MS SQL Server 2008, Oracle PL/SQL, Informatica Power Center 9.6.1, Informatica B2B, Data Transformation studio 4.0, MS Access, SSIS, TFS, Tivoli, Tableau.

Confidential, Des Moines, IA

ETL Developer

Responsibilities:

  • Involved in the full life cycle development of the project including design, development, and testing.
  • Analyzed the business requirements and suggested changes to the design accordingly.
  • Implemented code using various Informatica Transformations like Joiner, Expression, Lookup, Aggregator, Router, and etc.
  • Loaded the data into the XML and Flat files.
  • Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
  • Extended logic for some of the existing mappings in the system to meet enhancement procedures.
  • Used Lookup Transformation to lookup the values in Flat Files.
  • Involved in creation of various UNIX scripts which help the ETL scheduling jobs and help in initial validations of various tasks.
  • Applied partitioning at session level for the mappings which involved loading data to target using target lookup to avoid duplicates records.
  • Involved in designing of star schema based data model with dimensions and facts.
  • Extensively worked with Slowly Changing Dimensions Type1, Type2, for Data Load
  • Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
  • Extensively used ETL tool to load data from both Fixed Width as well as Delimited Flat Files. Extracted and loaded data in databases Oracle and SQL Server
  • Involved in massive data cleansing prior to data staging.
  • Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
  • Used Autosys Scheduler to automate the Workflows.
  • Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent sessions and scheduling them to run at specified time with required frequency.
  • Created scripts to create and delete temporary files at the session level.
  • Copied/Exported/Imported the mappings/sessions/work lets/workflows from development to Testing and promoted to Production.

Hardware/Software: Informatica 9.6, MS SQL Server 2008 R2, Oracle 12c, PL/SQL, shell scripting, Perl script, Autosys, jRuby 1.7, TortoiseSVN 1.8, TOAD, Passport, UNIX, and ESP.

Confidential, New York

ETL Informatica Developer

Responsibilities:

  • Involved in the full life cycle development of the project including design, development, and testing.
  • Analyzed the business requirements and suggested changes to the design accordingly.
  • Implemented code using various Informatica Transformations like Joiner, Expression, Lookup, Aggregator, Filter, Router, Update Strategy and etc.
  • Loaded the data into the XML and Flat files.
  • Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
  • Extended logic for some of the existing mappings in the system to meet enhancement procedures.
  • Used Lookup Transformation to lookup the values in Flat Files.
  • Involved in creation of various UNIX scripts which help the ETL scheduling jobs and help in initial validations of various tasks.
  • Used stored procedures for truncating the tables and deleting the rows from error logs.
  • Applied partitioning at session level for the mappings which involved loading data to target using target lookup to avoid duplicates records.
  • Involved in designing of star schema based data model with dimensions and facts.
  • Extensively worked with Slowly Changing Dimensions Type1, Type2, for Data Load
  • Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
  • Extensively used ETL tool to load data from both Fixed Width as well as Delimited Flat Files. Extracted and loaded data in databases such as DB2, Oracle and SQL Server
  • Involved in massive data cleansing prior to data staging.
  • Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent sessions and scheduling them to run at specified time with required frequency.
  • Created scripts to create and delete temporary files at the session level.
  • Copied/Exported/Imported the mappings/sessions/work lets/workflows from development to Testing and promoted to Production.
  • Involved in production support for issue fixes and helping out from the system failures.

Hardware/Software: Informatica 8.6, MS SQL Server 2008 R2, DB2 v8.2, Oracle 11g/10g, PL/SQL, Rapid SQL 8.5/7.x, XML, Windows Server 2008, UNIX/LINUX, Oracle Business Intelligence Enterprise Edition (OBIEE 10g), Autosys R11/4.5.

Confidential, Somerset, NJ

ETL Developer

Responsibilities:

  • Extensively worked with Source Qualifier Transformation to join the homogeneous sources
  • Extensively worked with Joiner Transformation to join the heterogeneous sources
  • Worked with various Databases for extracting the files and loading them into different databases
  • Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
  • Involved in applying the masking rules for specific users in oracle database using dynamic data masking tool.
  • Analyzed existing SSIS packages and created technical designed documents.
  • Responsible for migrate the workflows from development to production environment
  • Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
  • Modified Unix Shell Scripts for executing the Informatica workflows.
  • Extensively worked on Informatica Designer components Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
  • Managed the job scheduling using Control-M.
  • Involved in data modeling and designed the Data Warehouse using snowflake Schema methodology.
  • Developed various mappings to load data from various sources using different Transformations including Router, Aggregator, Joiner, Lookup, Update Strategy, Stored Procedure, Sorter, Filter, Source Qualifier, Expression, Union and Sequence Generator to store the data in target tables.
  • Involved in developing OLAP models like Facts, Measures and Dimensions (Data Models).
  • Developed mapping based on the mapping specification document that indicates the source tables, columns, data types, transformation required, business rules, target tables, target columns and data types.
  • Converted SSIS packages into Informatica mappings.
  • Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level
  • Involved in writing Stored Procedures in SQL and extensively used this transformation in writing many scenarios as per the requirement
  • Involved in Unit Testing, Integration Testing and End-End Testing

Hardware/Software: Informatica Power Center 8.6, oracle 10g, PL/SQL, Unix Shell scripts, Control-M, SSIS, Oracle Business Intelligence Enterprise Edition (OBIEE 10g).

Confidential, Kansas City, MO

ETL Developer

Responsibilities:

  • Involved in gathering and analyzing the requirements and preparing business rules.
  • Generated Entity-Relationship diagrams based on actual values and relationships held in source data.
  • Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
  • Data extracted from different databases like Oracle and external source systems like flat file using ETL tool.
  • Designed and Developed complex mappings by using Lookup, Expression, Update, Sequence Generator, Aggregator, Router, Stored procedure transformations to implement complex logics while coding a Mapping.
  • Mapplets and reusable transformations have been part of the mappings since different data types conversions have to be dealt multiple times which are similar and also most of the lookups have been similar
  • Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides.
  • Loaded Oracle tables from XML sources.
  • Good understanding of source to target data mapping and Business rules associated with the ETL processes.
  • Importing Source/Target tables from the respective databases by using Execute Package Task using Control Tasks in SQL Server Integration services(SSIS)
  • SSIS packages created using different transformations, like Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion
  • Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
  • Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Performance and Unit Testing of Informatica Sessions, Batches and Target Data.
  • Involved in all phases of Software Development like Code Development, Unit Testing using debugger, Integration Testing, Code Promotion, and Preparation of Checklists at each phase.
  • Analyzed the issue if any, in flat file and Communicate with concerned person to resolve issue.

Hardware/Software: Informatica 8.6/8.1, SSIS 2012, Oracle 10g, PL/SQL, Teradata V2R6/5, SQL developer, Oracle Business Intelligence Enterprise Edition (OBIEE).

Confidential, Whippany, NJ

ETL / Informatica Developer

Responsibilities:

  • Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation
  • Used Informatica PowerCenter 8.1 and its all features extensively in migrating data from OLTP to Enterprise Data warehouse.
  • Created batch scripts and used to call them from command prompt to load the data warehouse Facts.
  • Involved in creation of Folders, Users, Repositories and Deployment Groups using Repository Manager.
  • Extracted data from different sources like Oracle, flat files, XML, DB2 and SQL Server loaded into DWH.
  • Created complex mappings in PowerCenter Designer using Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
  • Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 8.1.1, since different datatype conversions have to be dealt multiple times which are similar and also most of the lookups have been similar
  • Extensively used Erwin for Logical and Physical data modeling and designed Star Schemas.
  • Handled slowly changing dimensions (Type I, Type II) based on the business requirements.
  • Worked extensively with different caches such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
  • Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance
  • Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
  • Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
  • Involved in Performance tuning for sources, targets, mappings and sessions.
  • Wrote PL/SQL stored procedures, cursors for implementing business rules and transformations.
  • Created deployment groups, migrated the code into different environments.
  • Worked closely with reporting team to generate various reports.

Hardware/Software: Informatica Power Center 8.6.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SQL Server 2005, UDB DB2 8.1, XML, Autosys, Oracle 10g, TOAD 7.6, SQL, PL/SQL, UNIX, Erwin, BO.

Confidential, CA

Informatica Developer/ Analyst

Responsibilities:

  • Analyzed the business requirements and framed the business logic for the ETL process.
  • Involved in massive data cleansing prior to data staging
  • Involved in developing complex mappings in Informatica PowerCenter 7.1.
  • Used Aggregator, Expression, Router, Filter, Update Strategy, Stored Procedure
  • Created variables and parameters in the Mapping Designer.
  • Used debugger in the Mapping Designer to troubleshoot logical errors.
  • Mapplets and reusable transformations have been part of the mappings since different data types conversions have to be dealt multiple times which are similar and also most of the lookups have been similar
  • Developed pre-session and post session scripts using UNIX.
  • Designed mappings involving target load order and constraint based loading
  • Worked with pmcmd command line program to talk with the Informatica server.
  • Performed Developer testing, Function testing, and Unit testing for the Informatica Mappings
  • Involved in Documentation regarding the ETL process.

Hardware/Software: Informatica Power Center 7.1, Windows NT, Oracle 8.0, SQL Server, UNIX.

Confidential

SQL Developer

Responsibilities:

  • Created .SQL scripts to handle new processes.
  • Worked in creating various critical business reports like descripting the financial status of the company.
  • Worked with data Architect in implementation and maintenance of database design, creation of database objects, Procedures, functions and triggers.
  • Developed PL/SQL procedures that extracted data from a data warehouse for policy reporting.
  • Created Records, Tables, Objects, Collections, Views, Materialized views and Global temporary tables (Nested Tables), and performed Error Handling.
  • Extensively used Cursors, Dynamic SQL and Functions.
  • Participated in Performance of the SQL.
  • Involved in development of process using SQL*LOADER, PL/SQL Package.
  • Run batch jobs for loading database tables from Flat Files using SQL*Loader.
  • Extensively used TOAD, SQL PLUS, SQL Developer and PLSQL developer for programming purposes.

Confidential

SQL Developer

Responsibilities:

  • Developed Complex SQL queries and written various dynamic SQL’s throughout the projects for adhoc report generation.
  • Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
  • Involved in the migration projects by migrating the data in old structure to new structures.
  • Extensively worked in Oracle SQL, PL/SQL, SQL*PLUS, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
  • Developed Shell scripts and schedule data loading as overnight job in cron utility.
  • Actively involved in requirement gathering and review meetings.
  • Analyzing the data model to understand the relationships.
  • Determining the criteria for archiving and purge of each application.
  • Write and modify UNIX shell scripts to manage Oracle environment.
  • Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.
  • Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.
  • Logical and Physical data modeling using ERwin, Dimensional, Relational/OLTP modeling.
  • Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.

We'd love your feedback!