We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

Milwaukee, WI

EXPERIENCE SUMMARY:

  • 7+ Years of experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing
  • Experience in Requirement Gathering and Requirement Analysis
  • Expert in Futuristic ETL Design considering Standardization, Reusability, and Scope to improve
  • Strong experience in installation, configuration and administration of Informatica Power Center and Power Mart Client, Server and designing/developing complex mappings, from varied transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Normalizer, Stored procedure and more
  • Proficient in using Workflow Manager Tools such as Task Developer, Workflow Designer and Worklet Designer. Experience in performance tuning of sources, mappings, targets and sessions
  • Experience in working with various versions of Informatica Powercenter Client tools
  • Experience in creating mappings to implement Slowing Changing Dimension
  • Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks
  • Experience in creating pre - session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs
  • Experience in integration of various data sources like Oracle, SQL Server, DB2, Flat files
  • Strong experience in complex PL/SQL packages, triggers, views, materialized views
  • Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping
  • Experience on Scripting and Programming using Unix Shell, HTML, DHTML, PL/SQL Stored Procedures, Triggers and Functions
  • Knowledge in Installation and configuration of Informatica server with sql server, oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc.
  • Experience includes thorough domain knowledge of Business Financial system, Banking, healthcare information technology, Insurance & Reinsure, Pharmacy claims systems, Telecom Industry
  • Proficient team player with the ability to communicate effectively at all levels of the design through production process
  • Experience creating Webi reports using SAP Business Object
  • Experience using Team Foundation Server(TFS) for Task and Defects
  • Experience in agile methodology and well-versed with sprints
  • Experience in scheduling tools like Autosys, Control M
  • Experience in Banking, Insurance and Clinical Trial Domain

TECHNICAL SKILLS:

ETL Tools: Informatica 8.6.1 / 9.5.1

Reporting Tool: SAP Business Object

Data Modeling Tools: Erwin

SDLC methodology: Waterfall and Agile

Operating System: UNIX, Linux, and MS Windows NT/2000/XP

Database: Oracle 10g/11g/12c, MS SQL Server, DB2

Document Management: SharePoint, BOX

Languages: SQL, PL/SQL, Shell Scripting

SQL Editor /Tools: SQL Navigator, Oracle SQL Developer, WinSQL, Oracle Toad, SQL Editor, PuTTy

Scheduling Tools: Distributed Control M job scheduler, Autosys, Auto Flow

Incident Management Tool: JIRA, TFS, Cherwell

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Senior ETL Developer

Responsibilities:

  • Estimate the impact of incidents and effort needed to fix the issues
  • Working with Architects on issues, possible solutions and design the solution approach for various ETL jobs.
  • Review changes done by other team members
  • Team spanning across globe, I was also involded in presenting the changes done by my team in change approval board (CAB) meetings
  • Providing bi-weekly status to downsteam teams on the active high and medium priority issues worked by my team
  • Acknowledge the issues and fix the issues in Cherwell and JIRA
  • Develop ETL mappings and unit test the code
  • Migrating changed codes to production and retesting the data again

Environment: Linux, Informatica PowerCenter 9.6.1, Sybase, DB2, Autosys, DBeaver, RapidSQL, Cherwell.

Confidential, Madison, WI

Senior ETL Developer

Responsibilities:

  • Helping in estimate the effort
  • Working with Architects on solution design, develop ETL mappings and unit test the code
  • Involved in importing source/target tables from the customer mount point and respective databases and created reusable transformations, mapplets and mappings using designer
  • We use different types of logics like Update logic, Replace Logic, Smart Logic, Cumulative data calculations
  • Implementing the new Customer flow according to the requirements that will meet Customer expectations
  • Create metadata entries and Autosys jobs
  • Migrate the code to INT and test the code
  • Acknowledge the issues and fix the issues in Team Foundation Server (TFS)
  • Migrate the code and load test data for QA and UAT
  • Performance test the code and make the documentations for production release
  • Migrating changed codes to production and retesting the data again

Environment: Linux, Informatica PowerCenter 9.6.1, Oracle, PostgreSQL, Control M, WINSQL, SQL Developer, SQLNavigator, and pgAdmin III service

Confidential, NJ

BI/ETL Developer

Responsibilities:

  • Worked with the Business Analysts and PME system architects to understand the requirements and design the Data Integration process to load the data to PME
  • Worked with new clients to understand their data requirement to serve them better
  • Worked with vendor teams from TCS and Infosys as a vendor manager
  • Designed technical layout considering Standardization, Reusability, and Scope to improve, if needed
  • Train and mentor the junior team members and vendors to make them understand the PME process flow/data model
  • Developed complex mappings to extract source data from heterogeneous databases Sybase, Mainframe DB2, Oracle, MQ queues, XML and flat files, applied proper transformation rules and loaded in to Data Warehouse
  • Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger
  • Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows
  • Worked closely with change management team and handled periodic releases
  • Ensured timelines are met for integrating new clients smoothly
  • Developed K-shell and Perl scripts to run from Informatica pre-session, post session commands. Set up on Success and on Failure emails to send reports to the team
  • Developing Mapping/Mapplet/Workflows involving various ETL processes using Informatica
  • Writing Unix scripts to process the source files, create parameter files, call workflows and send extract files to clients
  • Conducting and Participating Peer code reviews

Environment: : Linux, Informatica PowerCenter 8.6.1, DB2, PL/SQL, Unix Shell scripting, Autoflow, WINSQL, SQLNavigator, Erwin Data Modeling tool.

Confidential, NJ

ETL Developer

Responsibilities:

  • Extracted the source data from legacy systems and moving them into the staging area
  • Created Intermediate views
  • Created mappings and mapplets using Informatica
  • Designed ETL mappings using Informatica
  • Prepared the ETL specifications for the business logic
  • Documented each process
  • Prepared unit test plan documents
  • Worked on Informatica - Source Analyzer, Data warehousing Designer, Mapping Designer, Mapplet, and Transformations
  • Created SAS datasets using the metadata
  • Tested and migrated the scripts to the UAT environments by coordinating with the EDS team

Environment: Oracle Clinical, Linux, Informatica PowerCenter 9.5.1, Unix Shell scripting, WINSQL

Hire Now