We provide IT Staff Augmentation Services!

Etl Lead Developer/designer Resume

O Fallon, MO

PROFESSIONAL SUMMARY:

  • 12+ years of IT experience in Data warehouse - analysis, design, development, implementation and troubleshooting in ETL Tools - Informatica, Abnitio, SSIS, Talend, Data ware housing Methodologies and Data Modeling
  • Extensive experience in design and development of ETL involved in Source databases - Oracle, SQL Server, Netezza, XML, Flat Files ( fixed width, delimited), Main Frame (COBOL Files) and Target databases - Oracle, Netezza, XML, SQL Server 2005 and Flat Files ( fixed width, delimited )
  • Hands on experience in ETL using Informatica Power Center/Power Mart 9.5/8.X/7.x/6.x/5.x, Informatica IDQ 9.6/10.0
  • Expertised on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer
  • Strong Experience in using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer
  • Extensively used Informatica Repository Manager and Workflow Monitor
  • Strong experience in developing complex mappings using varied transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter,Ranker Joiner, Unstructured Data Option (UDO), Stored Procedure, Update Strategy and Re-usable transformations
  • Strong experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load
  • Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency
  • Extensive experience in error handling and problem fixing in Informatica
  • Strong Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements
  • 7+ years in Teradata development experience
  • Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files
  • Excellent knowledge in Creating database objects like Stored Procedure, Views, packages, functions and Triggers using PL/SQL
  • Strong working knowledge on BigData
  • Deep knowledge within SAP BW including ETL, data modelling and frontend development
  • Capable of processing large sets of structured, semi-structured and unstructured data and supporting systems application architecture using Hadoop
  • Good knowledge on Informatica Cloud and Informatica Cloud Real TIme
  • Good knowledge of UNIX Shell Scripting and Oracle 10g/9i/8i
  • Ability to prioritize multiple tasks
  • Good working knowledge in BI tools Cognos, Qlikview, Banking and Financial companies
  • Excellent working knowledge on Agile process/Scrums/Standup meetings
  • Self-motivated and able to work independently and as a member of a team
  • Excellent communication, interpersonal and analytical skills
  • Quick learner and adaptive to new and challenging technological environments

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.2/9.6/8.6/8.5/8.1/7.1/6.2.2/5.1.2/ Power Connect and Power Exchange, Power Mart 6.x/5.1, Informatica IDQ 9.6/10.0,MM,DIH BODI, Data stage 7.x/8.x,Abnitio 2.14,Informatica Cloud, SSIS 2005

Data modeling Tools: Erwin 4.2

Data Quality Tools: Trillium Software Data Quality Connector for Informatica, Dataflux dfp Power Studio

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2005, Netezza, Teradata,DB2, SYBASE, Flat files, COBOL Files

Data warehousing methodologies: Dimensional modeling - Star schema, snow flake schema

Other Tools & Utilities: SQL * plus, Toad, SQL Server Management Studio, SQL Server2005 SSIS, Qlikview, AutoSys, Appworx,Tidal, Microsoft Visio, Clearcase, Tivoli,Salesforce

Languages: SQL, PL/SQL, TSQL, C, VB

Scripting Languages: Unix Shell Scripting, Perl Scripting

Operating Systems: Windows XP/NT, UNIX (Sun Solaris, Linux, HP-UX), AIX

WORK EXPERIENCE:

Confidential, O’Fallon, MO

ETL Lead Developer/Designer

Responsibilities:

  • Participate in Business, Functional and Technical Review meetings with all stakeholders of the Data Management Services group
  • Contribute to the Project Planning, Estimation, Resource and Task Planning
  • Worked with project and application teams to ensure that they understand data quality standards, architecture guidelines and designs
  • Worked with source system analysis, identification of key data issues, data profiling and development of normalized star/snowflake schemas
  • Provide development Support to the decommissioning of Release 1.5 Master Data Management Retirement initiatives
  • Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files, Persistent Cache
  • Used UNIX scripting to apply rules on the raw data within AWS
  • Used Redshift within AWS
  • Perform troubleshooting, code fix, and root-cause analysis of any issues and defects identified for the Data Services
  • Involved in Unit testing, System Integration testing, User Acceptance Testing
  • Provide support to deploy and troubleshoot ETL Informatica power center objects to different environments starting from Dev to Production
  • Worked on scheduling ETL jobs with third party scheduling tool Tidal
  • Provide Production go-live and Warranty support
  • Followed Agile process/Scrum and daily standups to meet deadlines, and maintaining tasks statuses on JIRA
  • Monitor all alerts and do the needful to clear the alerts, escalate issues wherever required
  • Provide 24*7 operational support to all production activities
  • Provide proactive risk identification and mitigation
  • Manage release calendar and keep all stakeholders updated on the release schedule
  • Communicate production issues to the impacted user groups
  • Developed various shell scripts using Korn Shell to Integrate various components
  • Worked on resource provisioning and loading for Informatica Metadata Manager
  • Worked on Informatica DIH to create Publications/Subscriptions

Environment: Informatica Power Center 10.1, Informatica IDQ 10.2, Informatica MM 10.2Informatica DIH 10.2,Amazon AWS, Oracle 11G, DB2, SQL Server, Flat files, PL/SQL, HADDOP HIVE, HDFS, SQL*Plus, TOAD 11.6, UNIX, Shell Scripting, Tidal, Erwin, Microsoft Visio

Confidential, IRVING TX

On Shore/Off Shore Lead ETL Designer/Developer

Responsibilities:

  • A Lead ETL Designer - gather Business Requirements, scoping, Elevated level design and gap analysis
  • Translated user requirements into system solutions and Data Architecture documentation for complex systems
  • Worked with project and application teams to ensure that they understand data quality standards, architecture guidelines and designs
  • Designed and optimized database architecture, complex queries and stored procedures for OLAP and unstructured data services
  • Worked source system analysis, identification of key data issues, data profiling and development of normalized star/snowflake schemas
  • Prepared Technical Specification Documents, Source to Target ETL mapping Documents and led design reviews with client and participate in Data Warehouse & ETL and reporting requirements meetings
  • Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files, Persistent Cache
  • Worked with Data integration using HL7 message through MQ
  • Worked on EDI data formats for 837, 835, 834, 270
  • Worked on building interfaces for Welcentive analytics for population health worked on XML sources and xml parsers (for mid-stream parsing) worked on Teradata health care model subject areas of Encoutners and pharmacy
  • Followed Scum Agile process to meet deadlines
  • Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load
  • Worked on migration on Targets from Sql server to Teradata
  • Need to implement the Data Quality rules requested by business in the incoming transformation stages using IDQ
  • Developed mappings, Process Sequence, Dictionaries, reference tables, rules
  • Data profiling and scorecard in collaboration with Data Architect
  • Complex quality rule development and immentation patterns with cleanse, parse, standardization, validation, exception, notification and reporting with ETL and Real-Time consideration
  • Worked on IDQ Address Doctor for pharmacy location reports
  • Involved in Unit testing, System Integration testing, User Acceptance Testing
  • Worked on Informatica Code Migration across various Environments
  • Involved in Production Support and Knowledge Transfer sessions

Environment: Informatica Power Center 9.6.1/10.1.0 , Informatica IDQ 10.0,Informatica TDM 9.6.1, Oracle 11G, Teradata 14/15, Flat files, HL7 MQ, EDI Files, PL/SQL, SQL*Plus, TOAD 9.1, UNIX, Shell Scripting, Tivoli, Erwin, Microsoft Visio

Confidential, Portland, OR

Sr. ETL Designer/Developer

Responsibilities:

  • A Sr. ETL Designer - gather Business Requirements, scoping, High level design and gap analysis
  • Created Data models, translated user requirements into system solutions and Data Architecture documentation for complex systems
  • Worked with project and application teams to ensure that they understand data quality standards, architecture guidelines and designs
  • Designed and optimized database schema, architecture, complex queries and stored procedures for OLAP and unstructured data services
  • Worked source system analysis, identification of key data issues, data profiling and development of normalized star/snowflake schemas
  • Prepared Technical Specification Documents, Source to Target ETL mapping Documents and led design reviews with client and participate in Data Warehouse & ETL and reporting requirements meetings
  • Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files, Persistent Cache
  • Used Teradata utilities fastload, multiload, tpump to load data, wrote Fastexport scripts to export data, wrote BTEQ scripts to transform the data
  • Designed and implemented Audit control and Exception control strategies
  • Created Stored procedures to collect stats on table level and schema level
  • Followed Scum Agile process to meet deadlines
  • Integrated Salesforce with Informatica cloud and extracted data from Oracle into Saleforce.com
  • Provided solutions for various performance bottle necks in Informatica Mappings
  • Designed and Developed Tivoli scripts to Schedule Informatica workflows
  • Developed various shell scripts using Korn Shell to Integrate various components
  • Created test cases and pseudo test data to verify accuracy and completeness of ETL process
  • Involved in Unit testing, System Integration testing, User Acceptance Testing
  • Involved in Informatica Code Migration across various Environments
  • Involved in Production Support and Knowledge Transfer sessions

Environment: Informatica Power Center 8.6.1/9.5.1 , Talend 4.1, Salesforce, Oracle 11G, Teradata 13.11, Flat files, PL/SQL, SQL*Plus, TOAD 9.1, UNIX, Shell Scripting, Tivoli, Erwin, Microsoft Visio

Confidential, Portland OR

Sr. ETL Designer/Developer

Responsibilities:

  • Architecture designed and implemented EDW using ETL - Informtica
  • Integrated multiple data source structures using Informatica Power Center Designer - Extract & Transform the data from various source systems by incorporating various business rules for different applications by using the different objects and functions which the tool supports
  • Analyzed requirements and gather Business Requirements, scoping, Elevated level design and gap analysis
  • Designed and developed data plans and strategies for EDW in Teradata env
  • Extensively used the transformations like Expression, Aggregator, Router, Sequence generator, Lookup transformations, Update strategy and stored procedure transformation to create mappings
  • Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements
  • Created and executed workflows using Workflow Manager
  • Understanding existing business model and customer requirements
  • Involved in the development of Informatica mappings and trouble shootings.
  • Created Datamaps for AS400 journals using Informatica Power Exchange
  • Involved in creating mappings for CDC (change Data Capture) Data Extraction from AS 400 using Informatica Power Exchange
  • Extensively worked with Informatica Recovery Sessions
  • Error Handling in Informatica mappings
  • Created and monitored the sessions and workflows
  • Utilized Informatica tools like Source Analyzer, Data Warehousing designer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager
  • Daily ETL Load Process, BW Load Process, Master Data Matching, Tuning and Cleansing
  • Developed Informatica Mappings and tuned for better Performance
  • Worked with Informatica Debugger to debug the mappings in Designer
  • Data Enhancements and deliverables done to QA Environment
  • Involved in loading data from source to target using different loaders like TPUMP, FASTLOAD, MULTILOAD and Teradata Parallel Transporter (TPT) (LOAD, STREAM, EXPORT etc.,)
  • Created Data Profiling mappings using Informatica Designer
  • Developed many custom UNIX scripts, Informatica maps, PL/SQL programs and SQL*Loader scripts to provide a best-fit solution for a variety of data sources
  • Worked with SAP team on SAP BW including ETL, data modelling and frontend development
  • Designed and developed UNIX Shell scripts for Scheduling and Monitoring the Informatica Jobs

Environment: Informatica Power Center 8.6, Informatica Power Exchange 8.6, DB2, SQL Server 2005, SAPBW, Flat files, PL/SQL, SQL*Plus, SQL Assistant, iSeries(AS400), Teradata V13R5, Netezza, UNIX, Shell Scripting, Autosys, Erwin 4.2, Microsoft Visio

Confidential, St. Louis, MO

Sr. ETL Designer/Developer

Responsibilities:

  • Working with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data Translated user requirements into system solutions
  • Involving in Data Analysis of the OLTP system to identify sources data elements
  • Working with Oracle, Flat file, Mainframe source systems and Oarcle target systems
  • Worked with Physical, Logical Data Modeling and Database design
  • Creating Oracle tables, views, constraints, indexes and collates on table level
  • Written various Analytical Functions, triggers, Functions and stored procedures on Oracle 11g
  • Preparing Technical Specification Document
  • Preparing Source to Target ETL mapping Documents
  • Designing and developing Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files
  • Implementing Type2 Dimension logic in mappings using Informatica Designer
  • Working on solutions for various performance bottle necks in Informatica Mappings
  • Migrating the Informatica jobs from older version to new version Using Version Control
  • Developing various Unix shell scripts to Integrate various components
  • Developed and implemented Audit control and Exception control Strategies
  • Created test cases and pseudo test data to verify accuracy and completeness of ETL process
  • Involving in Unit testing, User Acceptance Testing and documented the results
  • Worked on GPG encryption/Decryption and secured FTP to send the encrypted files to external vendor Arch-Way

Environment: Informatica Power Center 8.5.1, Oracle 11G, Mainframe, Flat files, PL/SQL, SQL*Plus, TOAD 9.1, UNIX, Shell Scripting, Approx, Erwin 4.2, Microsoft Visio

Confidential, Irving TX

Sr. ETL Designer/Developer

Responsibilities:

  • Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data Translated user requirements into system solutions
  • Involved in Data Analysis of the OLTP system to identify sources data elements
  • Worked with Oracle, Flat file source systems and SQL Server target systems
  • Created Sql Server tables and views
  • Created SSIS (DTS) packages
  • Created constraints, indexes and collates on table level
  • Written various cursors, triggers, Analytical Functions and stored procedures on Sql Server 2005
  • Prepared Technical Specification Document
  • Prepared Source to Target ETL mapping Documents
  • Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files
  • Worked on converting various Abnitio components (from different source systems) like Rollup, Join reformat and techniques like parallel processing component folding etc into Informatica objects
  • Implemented Type2 Dimension logic in mappings using Informatica Designer
  • Provided solutions for various performance bottle necks in Informatica Mappings
  • Migrated the Informatica jobs from older version to new version Using Version Control
  • Designed and Developed Autosys jil scripts to Schedule Informatica workflows
  • Developed various shell scripts to Integrate various components
  • Developed and implemented Audit control and Exception control Strategies
  • Created test cases and pseudo test data to verify accuracy and completeness of ETL process
  • Involved in Unit testing, User Acceptance Testing and documented the results.
  • Involved in Informatica Code Migration across various Environments
  • Involved in Production Support and Knowledge Transfer sessions

Environment: Informatica Power Center 8.6.1, SSIS, Dataflux dfpPowerStudio, Oracle 10G, SQL Server 2005, MicroStrategy, Flat files, PL/SQL, SQL*Plus, TOAD 9.1, SQL Server Management Studio, UNIX, Shell Scripting, Autosys, Erwin 4.2, Microsoft Visio

Confidential, Lexington, MA

Sr. ETL Designer/Developer

Responsibilities:

  • Responsible for reviewing Business Requirement document
  • Translated user requirements into system solutions
  • Involved in Logical Data Modeling and Database design
  • Designed and developed Oracle Star Schema Datamart
  • Involved in Data Analysis of the OLTP system to identify sources data elements
  • Worked with Oracle, Flatfiles and SQL Server source systems
  • Prepared Technical Specification Document
  • Prepared Source to Target ETL mapping Documents
  • Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files
  • Provided solutions for various performance bottle necks in Informatica Mappings
  • Designed and Developed Autosys jil scripts to Schedule Informatica workflows
  • Developed various shell scripts using Korn Shell to Integrate various components
  • Developed and implemented Audit control and Exception control Strategies
  • Created test cases and pseudo test data to verify accuracy and completeness of ETL process
  • Involved in Unit testing, System Integration testing, User Acceptance Testing
  • Involved in Informatica Code Migration across various Environments
  • Involved in Production Support and Knowledge Transfer sessions

Environment: Informatica Power Center 8.1.1, Sybase IQ 12.7, Oracle 10G, XML, SQL Server, Relational Junction, Flat files, Aqua Data Studio 6.5, PL/SQL, SQL*Plus, TOAD 9.1, UNIX, Shell Scripting, Autosys, Erwin 4.2, Microsoft Visio, Salesforce.com

Confidential, Dallas, TX

Sr. ETL Designer/ Developer

Responsibilities:

  • Responsible for the Business Analysis and Requirements gathering, create a road map for the Data warehouse designing
  • Translated user requirements into system solutions
  • Involved in Data Analysis of the OLTP system to identify the source tables and their reference data tables for extraction of the data
  • Worked with Oracle and SQL Server source systems
  • Implementing Screen Door Process for Flat file sources for data validation and data cleansing
  • Designing and developing Mappings using Mapping Designer to load the data from various sources using different transformations like Unconnected and Connected lookups, Router, Unstructured Data Option (UDO), Aggregator, Sorter, Ranker, Joiner, Stored Procedure, Update Strategy and Re-usable transformations
  • Creating Sessions, Workflows and Worklets for data loads using Workflow Manager
  • Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks
  • Developed and implemented Error Handling Strategies
  • Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment
  • Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements
  • Preparing and using test data/cases to verify accuracy and completeness of ETL process
  • Maintaining issue log of the issues during the UAT phase for future reference
  • Migrating Folders, Mappings across repositories and folders
  • Actively involved in the production support and transferred knowledge to the other team members

Environment: Informatica Power Center 8.1, Power Exchange 8.1.1, Oracle 9i, SQL Server, VSAM Files, Flat files, Microsoft Excel 2000, Microsoft Visio, PL/SQL, SQL*Plus, TOAD 6.3.11.1g, Windows XP Professional, UNIX, Perl Scripting, Erwin 4.2

Confidential, Houston, TX

Lead ETL Designer/Developer

Responsibilities:

  • Responsible for the Business Analysis and Requirements gathering, create a road map for the Data Staging area
  • Translated user requirements into system solutions
  • Created Logical Data Modeling (Star Schema and Snow flake Schema) and Dimensional Modeling (Slowly Changing Dimensions)
  • Involved in Data Modeling sessions using Erwin
  • Involved in Data Analysis to identify the sources tables and their reference data tables for extraction of the data
  • Creating and modifying Oracle Database tables as per the design requirements and applying Constraints to maintain complete Referential Integrity and creating indexes for performance
  • Designing and developing Mappings using Mapping Designer to load the data from various sources using different transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter,Ranker Joiner, Stored Procedure, Update Strategy and Re-usable transformations
  • Creating Sessions, Workflows and Worklets for data loads using Workflow Manager
  • Worked on Performance Tuning (ETL Process improvements) of various mappings and sessions to identify and remove Bottle Necks
  • Worked on performance tuning of SQL Statements and on Database
  • Developed and implemented Error Handling Strategies
  • Fixed various Data Quality Issues
  • Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment
  • Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements
  • Preparing and using test data/cases to verify accuracy and completeness of ETL process
  • Maintaining issue log of the issues during the UAT phase for future reference
  • Tracking the issues using Remedy tool and fixed the issues
  • Migrating Folders, Mappings across repositories and folders
  • Writing scripts to validate the Data
  • Actively involved in the production support and transferred knowledge to the other team members

Environment: Informatica Power Center 7.1.4, Oracle 9i, Siebel, Microsoft Excel 2000, Microsoft Visio, PL/SQL, SQL*Plus, TOAD 6.3.11.1g, SQL Server 2005 SSIS, Windows XP Professional, UNIX, Perl Scripting, AIX, Erwin 4.2., Remedy, MS Virtual Source Safe, Share Point

Confidential, New York City, NY

ETL Designer/Developer

Responsibilities:

  • Worked with Business Analyst, DBA for requirements gathering, business analysis, and build the infrastructure of the data flow
  • Translated business requirements into enterprise data warehouse architectural design
  • Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Unconnected and Connected lookups, Router, Aggregator, Joiner, Stored Procedure, Update Strategy for Daily Load
  • Designed and Developed Mappings for implementing CDC by tracking the changes in critical fields required by the user
  • Creating Sessions, Batches for data loads using Workflow Manager for Daily load.
  • Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks
  • Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment
  • Worked with Tuning the SQL Statements and Database
  • Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements
  • Preparing and using test data/cases to verify accuracy and completeness of ETL process
  • Worked with Clearcase
  • Maintaining issue log of the issues during the UAT phase for future reference
  • Involved in Migration of project from Development to Test environment and then to Production environment
  • Actively involved in the production support and transferred knowledge to the other team members

Environment: Informatica Power Center 6.2.2 / 5.1.2 , Oracle 9i, Sybase, Teradata, DB2, Microsoft Excel 2000, PL/SQL, SQL*Plus, TOAD 6.3.11.1g, AutoSys, Clearcase, Windows XP Professional, UNIX, Shell Scripting, Erwin 4.2

Confidential, Houston, TX

ETL Developer

Responsibilities:

  • Designed mappings that loaded data from flat-files to the staging tables
  • Used Informatica tools like Source Analyzer for Sources, Warehouse Designer for declaring targets, Mapping Designer for developing mappings, Mapplet Designer for Reusable Mapping
  • Used Transformations like Lookup, Aggregate, Expression, Router, and Joiner and Sequence generator were applied. Shell commands were written to perform clean-up operations
  • Performed tests on variable record-length mappings that incorporated the use of a filler, to see if the mappings would break when the record-length varied
  • Scheduled and unscheduled workflows and used UNIX command tasks to automate the entire process of fetching the source file from a different path and ftp it onto the server
  • Performed incremental aggregation, built slowly changing dimensions using lookup and update strategy transformations, used mapping parameters and variables as well as re-usable transformations
  • Implemented performance tuning by using lookup caches, using tables with fewer rows as the master table in joiner transformations, dropped indexes and re-created them after loading data to targets and increased the commit interval
  • Involved in the designing of the Business Objects Universe

Environment: Informatica (PowerCenter 6.1), Oracle 8i, MS SQL Server 7.0, Flat Files, Erwin 4, SQL, PL/SQL, LINUX, Windows 2000/NT

Hire Now