SUMMARY

• Over 10+ years of experience in ETL Development with Informatica PowerCenter tool and their implementation in Business Intelligence problems holding the skills in Business Analysis, Creating user stories, User Acceptance Testing, Client Relationship and Delivery Management in Onsite - Offshore model.
• Experience in product life cycle management familiarity with amazing ability to aid technical team members, developers and support teams, outstanding troubleshoot workflow issues and superior communication skills.
• Experience in creating Source to Target Mapping (STM) Documents based on the requirements.
• Design, Development, Support and Testing of SCD Type1,Type2 & Type3 ETL Mappings, complex Day/Period dimension mappings specific to Business periods using Informatica PowerCentre.
• Strong understanding of Data Modelling (Dimensional and Relational) concepts like Star-Schema and Snow-Flake Schema - different Fact and Dimensional Tables.
• Proficient in using Informatica Designer, Workflow Manager and Workflow Monitor.
• Exposure in Data Warehousing and DataMart using Informatica.
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Experience in creating reusable mapplets, parameters and variables.
• Experience in debugging mappings to Identify bugs in existing mappings by analyzing the data flow.
• Experience in writing complex SQL Queries to perform unit testing of the developed ETL code.
• Proficient exposure on SQL Joins, analytical functions and different performance tuning techniques.
• Experience in writing the most optimal SQL code to retrieve datasets faster.
• Experience in reading SQL execution plan to identify the bottleneck of the issues and apply corresponding tuning techniques to make the query optimal.
• Created Indexes, used SQL hints to force the optimizer to pick the optimal execution plan.
• Experience in Unix commands for various ETL needs and worked on integrating data from flat files.
• Experience in Informatica mapping specification documentation, tuning mappings to increase performance, and schedule workflows.
• Experience in monitoring and fixing the issues in Production workflows and having good experience in Debugging of mapping for getting troubleshooting information about data and error conditions.
• Performed unit testing and prepare UAT test case results for newly developed ETL objects
• Deployment of ETL Objects from Development to QA, UAT & Production environments using JFrog Artifactory and UDeploy software.
• Experience in writing user stories which can be understood by all the project members.
• Involved in developing Innovative Solutions for clients that reduce their cost in application and helped the team for speedy and more efficient work.
• Ensures that applicable regulations, guidelines and internal procedures related to quality assurance (QA) and validation are followed and applied.
• Experience in working in an Agile environment.
• Extensively used MS Excel for data extraction, data validation, data manipulation and present the same to the higher management for their analysis.
• Strong written and verbal communication skills & interpersonal skills with proven abilities in Customer Relationship Management & Team Management.
• Experience in handling client queries and providing effective responses to clients independently.
• Have strong commitment to the task assigned and completely take the ownership until it is complete or successfully deployed.
• Logical, Analytical and good interpersonal skills, Commitment to perform quality work, and an Excellent Team player.
• Good knowledge of quality standards and software development life cycle processes which include requirement gathering, detailed design, coding, testing and defects handling.

TECHNICAL SKILLS

Informatica Power Center: Informatica PowerCenter 9.x, 10.x -A very good experience in Informatica Development using Designer, Workflow Manager, Workflow Monitor, Repository Manager.

Database: Oracle, MS SQL, Teradata

Tools: TOAD, SQL Developer, WinSCP, Putty, Jira, JFrog Artifactory, UDeploy, IBM Clear Case, HP Quality Center, HP WorkBench for Migrations, DAC, Teradata Studio.

DAC: Data Warehouse Administration Console - Has an Extensive knowledge in using this tool for scheduling the Informatica workflows in lower environments as well as production environments.

Operating Systems: Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential - Pittsburgh,PA

Sr ETL Developer

Responsibilities:

• Gathering requirements from business analysts and designing and developing Source to Target Mapping Documents (STTM) documents.
• Development of ETL (Extract, Transform and Load) code components like mappings, Workflows, sessions from business requirements and design plan.
• Develop mappings Informatica Designer to integrate data from various sources like Oracle, flat files and loaded into target.
• Participate in Product Backlog grooming sessions and Sprint Backlog grooming sessions to prioritize the stories for the coming sprints and releases based on the needs of the business.
• Develop various complex mappings using PowerCenter Designer involving Transformation like Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator.
• Create mappings in Informatica PowerCenter Designer for implementing SCD-Type 1 & Type 2 with update strategy and dynamic cache lookup transformations as per business logic.
• Implement various Performance Tuning techniques on Sources, Targets and Transformations.
• Use Informatica debugging techniques to debug the mappings and use session log files and bad files to trace errors occurred while loading.
• Create Sessions and workflows in Workflow Manager and Scheduled at specified frequency.
• Performing unit testing by writing the SQL Queries in the Source and Target systems.
• Deploy from Dev to QA, UAT and Prod environments by exporting objects from Dev Repository folder to XML file.
• Work with Prod Support Team, DBA Team, Release Management Team and Admin team to migrate the code later to Production environments.
• Good exposure to the usage of various UNIX commands as per the process needs.
• Adhere to the ‘Agile’ software development lifecycle methodology during the complete course of the project.

Confidential - Boston, MA

Sr. ETL Developer

Responsibilities:

• Worked with business users to clarify requirements and translate the requirement into technical specifications.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirement documents and ETL specifications.
• Created Dimensions and Fact tables for the data mart and also implemented SCD (Slowly
• Changing Dimensions) Type I and II for data load.
• Extraction, Transformation and Load was performed using Informatica Power Center
• Developed standard and re-usable mappings, mapplets using various transformations like expression, aggregator, joiner, source qualifier, lookup, and Router. Also, developed mappings using parameters and variables.
• Developed complex mappings in Informatica Power Center to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected),
• Expression, Aggregate, Update Strategy, Joiner, Filter and Router.
• Tuned Informatica mappings/sessions for better ETL performance by eliminating bottlenecks.
• Used Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files and SQL Server to the Data mart on Oracle database.
• Accessed the mainframe file by creating data maps in Power exchange.
• Created mappings, complex workflows with multiple sessions, worklets with consecutive/concurrent sessions for loading fact and dimension tables into data mart presentation layer.
• Conducted performance tuning of Informatica components for daily and monthly incremental loading tables. Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.
• Used Workflow Manager for creating, validating, testing and running sequential and concurrent batches. Migration of the object between environments.
• Implemented source and target-based partitioning for existing workflows in production to improve performance so as to cut back the running time.
• Analyzed workflow, session, event and error logs for troubleshooting Informatica ETL process.
• Worked with Informatica Debugger to debug the mappings in Informatica Designer.
• Involved in creating test plans, test cases to unit test Informatica mappings, sessions and workflows.

Confidential - Pittsburgh, PA

ETL Developer

Responsibilities:

• Understand end-to-end business processes in required functional areas of ERP and gather requirements along with onshore counterparts and design simplified models to address business requirements.
• Implemented different BI Strategies for different reporting requirements.
• Analyzing the Functional Document and Technical design for approved scope.
• Working in DAC 11g (Data warehousing Administration Console)
• Experienced in performance tuning of mappings, sessions and workflows including partitioning.
• Extensively worked on Informatica Power Centre Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalize, Joiner, Update Strategy, Rank, Aggregator, Sorter and Sequence Generator.
• Interacting with Onshore people and DBAs and Admins team if any issues arise.
• Gathering the requirements from the users having the regular connection with the clients.
• Developing the Informatica Mappings from the Scratch according to the requirements of the Users.
• Scheduling and Monitoring the Loads through the tool called Data Warehouse Application Console (DAC).
• Resolving the defects based on the issues reported by the Users.
• Hands on Experience on using the HP Workbench tool for Migrating the objects across the environments.
• A Good experience of using the HP Quality center tool for defect tracking purposes.
• Tuning the Informatica tasks to improve the performance of the task run.
• Testing the code after Production deployment and confirming the Users for the final validations.
• Provide support to the Process team during the Product Testing phase and fixing the defects with less turnaround time.
• Release plan for deploying the data models built to Production
• Developed multi dimension hierarchies for US Steel Commercial reporting.
• Focused significant effort on SQL tuning ETL Redesigns, DAC performance to meet stringent SLA timings.
• Responsible for identifying new change requests, estimating the work effort and preparing the technical design and regression test plan.

Confidential - Minneapolis, MN

ETL Developer

Responsibilities:

• Gathered requirements from business analysts and designed and developed functional and technical specifications, Incorporated identified factors into Informatica mappings to build Data Warehouse.
• Developed Transformation logic and designed various complex mappings in the Designer for data load and data cleansing.
• Developed mappings, mapplets in Informatica Designer to integrate data from various sources like Oracle, flat files and loaded into target.
• Created reusable mapplets, transformations and mappings using Informatica Designer.
• Focused on fixed and delimited flat files, also worked with direct and indirect flat files
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Created mapping using various Transformations like update strategy, lookup, stored procedure, router, filter, Sequence generator, Joiner, aggregate and expression transformations in extracting data in compliance with business logic developed.
• Created Sessions, Reusable Worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Hands on experience in handling large volumes of data in production environments.

Confidential

Systems Engineer

Responsibilities:

• Worked closely with Developers and Management for requirements gathering.
• Configured and Managed SVN server for version control of development source code.
• Configured and managed SQL Server Databases as per client requirements in Dev, QA and Prod environments.
• Deployed and managed developed applications to IIS Web Server in Dev, QA and Prod environments.
• Configured and Managed SSL Certificates from DigiCert provider for Web Applications
• Worked on Database upgrades as per the requirement and migrated to newer versions when needed.
• Responsible for Database backups and restoring them when needed.
• Deployed the developed kolme(HR Management) and tQmlab(Lab management) applications in Client servers.