We provide IT Staff Augmentation Services!

Lead/sr Etl Developer Resume

Monroe, NC

SUMMARY:

  • ETL Developer with over 8+Years of IT experience in Data warehousing, Data Analysis,Development, Maintenance, Testing and Documentation.
  • Over 8 years of IT experience in System Analysis, Design, coding and testing of Data Warehousing implementations across multiple domains such as Insurance, Banking, and Pharmaceuticals.
  • 8 years’ experience in design, develop and maintaining Data Warehouses and Data Marts using INFORMATICA 10.2/9.6.1/8.6.1/8.1 , SQL Server2014, SSIS, Visual Studio 2013, Web Methods, Netezza, Oracle, DB2, Teradata, Toad
  • Expertise in Creation, Modification and Testing of Informatica Mappings, Mapplets, Workflows, Worklets and debugging and performance tuning of Informatica Mappings and Sessions.
  • Extensively worked on various transformations like Lookup, Joiner, Router, Union, SQL, Sorter, Aggregator, Expression, Web Services Consumer Transformations etc.
  • Extensively worked on Teradata Scripts (BTEQ, MLOAD, Fast Export, Fast Load), Informatica Designer, Work Flow Manager, Work Flow Monitor and Repository Manager.
  • Experience in Developing and Tuning T - SQL, PL/SQL Complex Queries, Stored Procedures, views, and error handling process.
  • Written SQLs and implemented Checks to capture Exception records (Invalid record) and loading them in Exception table.
  • Experienced in Performance tuning of critical Informatica jobs & database loader jobs and Data Warehousing Applications
  • Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions.
  • Strong experience in coding using SQL, PL/SQL Procedures.
  • Extracted data from various Data sources like Netezza, Oracle, Teradata, DB2, SQL Server, Mainframe, SAS and Worked on integrating data from flat files and COBOL Files and Web Services using Informatica.
  • Extensive Experience in unit testing, UAT testing and integrated testing of entire process flow.
  • Experienced in Deploying Informatica jobs from Development environment to Test environment and Test to Production Environment using Informatica export/import methodology.
  • Extensive experience in Production Support environment using AUTOSYS, Informatica, Netezza, Oracle, DB2, UNIX.
  • Proficient in Installing and Configuring Oracle Business Intelligence, both stand-alone & Enterprise Applications, Knowledge in DAC, Informatica Client/Server installation and configuration.
  • Handled critical job failures in the production environment and Involved in fixing the data issues in the EDW databases
  • Knowledge in designing Dimensional models for Landing, Cleansing and Staging areas.
  • Involved with every phase of the SDLC, including feasibility studies, design, and coding for large and medium business intelligence projects and continually provided value-added services to the clients.
  • Excellent knowledge and experience in data warehouse development life cycle, requirements analysis, dimensional modeling, Implementation of STAR, Snowflake schemas; Incremental loads, Change Data Capture and slowly changing dimensions.
  • Knowledge of Data Warehouse methodologies like Bill Inman, Ralph Kimball.
  • Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.

CAREER PROGRESSION

Confidential, Monroe, NC

Lead/Sr ETL Developer

Responsibilities:

  • Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification
  • Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development
  • Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development
  • Handling Offshore Teams and Co-ordinated with them on the ETL Development work efforts.
  • Created Informatica mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations
  • Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
  • Involved in Tuning critical Informatica jobs
  • Worked on SSIS packages for MES loads.
  • Involved in Code Reviews & suggested best practices.
  • Modify existing mappings and write new programs as needed.
  • Performed Unit Testing and Integration Testing for Data Warehousing Applications and tuned for better performance
  • Involved in 24/7 on-call support for DWH related jobs in Production environment.
  • Involved in Code Reviews & suggested best practices
  • Documenting High level and Low-level designs for development and enhancement changes.
  • Configuring and Customizing Oracle BI applications w.r.t customer’s specific customizations and operations.
  • Extensively worked on OBIEE 11g/11.1.1.X, OBIA (Financials, Custom Built OM, Manufacturing Analytics, Supply Chain) - Physical, Business and Presentation Layers.
  • Involved in extracting data from flat files, relational databases into staging area.
  • Created Historical Snapshot for various key metrics using ETL to help business analyze data.
  • Developed security for Dashboards/reports based on groups and users.
  • Create new/modified existing SDE’s and SIL’s Mappings as per the requirements. Created Custom mappings to update Facts and Dimensions creating/ modifying DAC execution plans.
  • Designed ETL Mappings Documents as per the requirement and OBIA Architecture and built custom DWH.
  • Performed Code review to ensure that ETL development was done according to the company’s ETL standard and that ETL best practices were followed.
  • Providing continuous enhancements and fixing of production issues.
  • Monitoring daily Incremental Load in Production environment and fix any issues during the Load.

Environment: INFORMATICA 10.2, SSIS, Window 7 x64, Windows Server 2008 R2, Red Hat Linux 5, OBIEE11.1, OBI Apps 7.9.6.3, DAC 11g, Oracle 11.1.2.3

Confidential, Charlotte, NC

Production Support Analyst

Responsibilities:

  • Accountability for all applications under INFA Tower.
  • Technical and process assistance to team members as needed.
  • Make sure all PROD Batch loads completed and not missed any SLA
  • Gather repeated issues/Long running jobs and come up with solutions
  • Responsible for updating Applications run book and KEDB on periodic basis.
  • Tracking all planned and unplanned releases and outages
  • Mentoring all news resources and L1 resources
  • On-Call support for all INFA Applications
  • Responsible for all UAT / PROD releases and handover calls
  • Making sure all PTs / JIRAs are closed within SLA timelines

Environment: INFORMATICA10.2, SQL Server, Teradata, SQL, UNIX, AUTOSYS, SSRS, Teradata Studio.

Confidential, Charlotte, NC

Senior DWH developer

Responsibilities:

  • Responsible for the analysis and reporting of customers channel behavior across all touch points from multiple databases
  • Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQLs, minus queries etc.
  • Converted ETL logics from Informatica mappings in to SSIS Packages
  • Created Stored procedures using SQL Server 2014.
  • Created Master Packages for executing SSIS packages.
  • Designed and developed packages to extract, transform and load data using SSIS (extensively worked on each loop, sequence containers, derived columns, data conversions, row count transformation, event handlers)
  • Written SQLs and implemented Checks to capture Exception records (Invalid record) and loading them in Exception table.
  • Created SSIS package to generate Exceptions file with all invalid records and notifying Source people.
  • Created SSIS packages to extract data from sources like MS SQL server 2014, Excel
  • Extensively worked on Informatica Designer, Work Flow Manager, Work Flow Monitor and Repository Manager.

Environment: Informatica 10.2, SSIS, MS Visual Studio 2013, SQL Server2014, Oracle, TFS, web Methods IntegrationServer7.1.2

Confidential, Fort mill, SC

ETL/Teradata developer

Responsibilities:

  • Involved in business requirements understanding (BRD Reviews).
  • Involved in Preparation of HLD (End to End Data flow design in ETL /Teradata scripts).
  • Extensively worked on Teradata Scripts (BTEQ, MLOAD), Informatica Designer, Work Flow Manager, Work Flow Monitor and Repository Manager.
  • Converted Informatica mappings in to Teradata scripts using Teradata Utilities.
  • Extensively worked on UNIX Shell scripting, and automation of ETL batch jobs
  • Experienced in Automating and Scheduling the Teradata SQL Scripts in UNIX using Korn Shell scripting.
  • Experienced working on large volume of Data using Teradata SQL and BASE SAS programming.
  • Implemented Slowly Changing Dimensions Type 1 and Type 2, methodology for accessing the full history of accounts and transaction information.
  • Wrote appropriate code in the conversions as per the Business Logic using Bteq scripts.
  • Loaded the data into the Teradata database using Load utilities like (Fast Export, Fast Load).
  • Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
  • Involved in Tuning critical Informatica jobs & database loader jobs.
  • Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities and Unix Shell scripts.
  • Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
  • Responsible for performance tuning which includes Tuned sources, targets, mappings, and sessions to improve the performance. To get optimal performance, used parameter files and mapping parameter, Variables in mappings and session variables in workflows.
  • Responsible for Error handling, bug fixing, Session monitoring and log analysis.
  • Involved in unit testing, UAT testing and integrated testing of entire process flow.
  • Deployed Informatica jobs from Development environment to Test environment and Test to Production Environment using Informatica export/import methodology.
  • Exposure in SAS with focus on Base SAS.

Environment: Teradata V15, BTEQ, MLOAD, CRONTAB, Unix Shell Scripting, INFORMATICA9.6.1, Toad, SAS, JIRA, TFS, Windows, Teradata SQL Assistance.

Confidential, Charlotte, NC

Informatica developer

Responsibilities:

  • Involved in business requirement gathering, which includes conducting Workshop sessions and translating the business inputs from workshop sessions into ETL design/technical documents.
  • Involved in End to End Data flow design in ETL Informatica mappings.
  • Extensively worked on Informatica Designer, Work Flow Manager, Work Flow Monitor and Repository Manager.
  • Created several complex Informatica mappings, Mapplets depending on client requirements. Extensively worked on Connected & Unconnected Lookups, Router, Expression, Source Qualifier, Aggregator, Filter, and Sequence Generator, SQL, Union, Web Services Consumer Transformation.
  • Extensively used Bulk Reader/Writer to significantly reduce ETL load times.
  • Extensively used Full Pushdown Optimization in Informatica to performance for Netezza DB loads.
  • Thorough understanding of External tables, Distribution, GROOM and other features of Netezza.
  • Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
  • Responsible for performance tuning which includes Tuned sources, targets, mappings, and sessions to improve the performance. To get optimal performance, used parameter files and mapping parameter, Variables in mappings and session variables in workflows.
  • Created Jil Scripts in AUTOSYS to schedule workflows.
  • Responsible for Error handling, bug fixing, Session monitoring and log analysis.
  • Involved in unit testing, UAT testing and integrated testing of entire process flow.
  • Deployed Informatica jobs from Development environment to Test environment and Test to Production Environment using Informatica export/import methodology.
  • Exposure in SAS with focus on Base SAS, SAS/SQL, SAS/Macros, SAS Enterprise Guide.

Environment: Informatica- Power Center 9.5.1, Netezza, Oracle 11g, Teradata, Toad, SAS, SAS DI, SAS DATA FLUX, UNIX, Toad, Windows, Tidal, SAS Enterprise Guide, AUTOSYS, AgenityWorkbench

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

  • Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification
  • Transforming high-level design spec to LLDs. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development
  • Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development
  • Used Informatica to load data from MITS (Oracle database) to T-MSIS (Oracle database).
  • Created Informatica mappings using the transformations like Source Qualifier, Union Aggregator, Expression, Lookup, Router, Filter, Update Strategy, normalizer and Joiner transformations
  • Created Complex SQL’s, to support T-MSIS.
  • Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
  • Involved in Tuning critical Informatica jobs & database loader jobs.
  • Involved in data analysis and created reports using SQLs.
  • Created Deployment groups and worked closely with DBAs to migrated Informatica code /database tables from Dev to QA and QA to Production.
  • Performed Unit Testing and Integration Testing and tuned ETL process for better performance
  • Involved in Code Reviews.

Environment: Informatica- Power Center 9.5.1, Oracle 11g, DB2, UNIX, Toad, Windows, SQL Developer, AUTOSYS, Shared Solutions.

Confidential, Raleigh, NC

Informatica Developer

Responsibilities:

  • Involved in Business Analysis and Requirements gathering and designing Technical Specification.
  • Used Informatica, Oracle, UNIX, and AUTOSYS to load into CTMS.
  • Dealt with different sources like oracle, DB2, and Flat files.
  • Created reusable transformations and Mapplets and used them in complex mappings.
  • Involved in creation of type1and 2 mappings.
  • Created Complex SQL’s, Stored Procedures and Functions to support ETL process.
  • Involved in Creation, modification of UNIX Shell scripting for supporting ETL process.
  • Worked with DBAs to get mappings migrated from Development to QA and QA to Production
  • Created Mappings, worked on Transformations, tested and coordinated until production.
  • Created Data maps for Non-Structured COBOL files using Informatica Power Exchange tool
  • Created, developed, Tested Jil scripts using AutoSys. Created shell scripts for retrieving data into Management reports.
  • Interacted with DEV, QA team to coordinate changes until Production.
  • Involved in Creating/Execution of Change Request, Problem Tickets, and Work Requests for production changes.
  • Involved in Code Reviews
  • Responsible for 24X7 Production support scheduling.

Environment: Oracle 9i, Informatica 8.x, Power Exchange Navigator 8.6.1, Flat Files, SQL, PL/SQL, Autosys, Maximo

Hire Now