SUMMARY:

• Senior ETL Informatica and datastage 11.5 Developer with hands on IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Infosphere Data stage and Informatica PowerCenter. Many years of experience in using Infosphere Data stage. Experience in using Informatica PowerCenter ( 7.1.3/8.6.1 )
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience with dimensional modeling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the datastage workflows and controlling the ETL flow.
• Strong with relational database design concepts.
• Extensively worked with Informatica and datastage performance tuning involving source level, target level and map level bottlenecks. Superior SQL skills and ability to write and interpret complex SQL statements and also skillful in SQL optimization and ETL debugging and performance tuning
• Expert in working and implementing Water Fall Model as well as Agile Methodology. Involved in delivery of multiple sprints in project. Also played role as scrum master.
• Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Strong experience with Informatica and datastage tools using real - time CDC (change data capture) and MD5.
• Experience in integration of various data sources like SAP, Oracle, Teradata, Netezza, Mainframes, SQL server, XML, Flat files. Very strong in Data Warehousing Concepts like Dimensions, De-normalization, SCD Type I, II and III, Facts, Surrogate keys, ODS, Staging area and cube.
• Realistic understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling.
• Expert in writing pseudo code, SQL queries and optimizing the queries in Oracle, SQL Server and Teradata. Good understanding of Views, Materailized View, Synonyms, Indexes, Partitioning, Database Joins, Stats and Optimization.
• Experience in developing very complex mappings, reusable transformations, sessions and workflows using Informatica ETL tool to extract data from various sources and load into targets.
• Experience in tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk load.
• Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced the execution time for huge volumes of data for a company merger projects. Heavily created mapplets, user defined functions, reusable transformations, look-ups.
• Strong business understanding of verticals like Banking, Brokerage, Insurance.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills

TECHNICAL SKILLS:

Operating Systems: Windows, Linux, Confidential -UX

Software / Applications: MS XP, MS 2000, MS Word, MS Excel, MS Access,Outlook,PowerPoint

Database: SQL Server 2008/2005/2000, Oracle 11g/10g/9i,Netezza

ETL: Informatica PowerCenter 7.1.3/8.6.1, IBM Datastage 11.3/11.7

Modeling: Framework Manager, PowerPlay Transformer

OLAP/BI Tools: Business Objects (Web Intelligence), Cognos 8 Series

Languages: XML, SQL, PL/SQL.

Web/Apps Servers: IBM Web Sphere 4x

Tools: TOAD, Eclipse

EMPLOYMENT HISTORY:

Confidential, Tampa, Florida

Senior ETL/ Datastage 11.5 Developer

Responsibilities:

• Lead development including methodologies for data transformations and processes in a corporate ETL solution
• Gathered and analyzed the requirements of the in-house business users for the data warehousing from JAD sessions.
• Collected the information about different Entities and attributes by studying the existing ODS and reverse engineering into Erwin.
• Defined the Primary keys and foreign keys for the Entities.
• Defined the query view, index options and relationships.
• Created logical schema using ERWIN 4.0 and also created the Dimension Modeling for building the Cubes.
• Designed staging and Error handling tables keeping in view the overall ETL strategy.
• Assisted in creating the physical database by forward engineering
• Create/manage batch processes
• Participate in the development of business strategy
• Access disparate data sources (databases, hardware devices, VSAM and flat files) and apply internal and external business rules, policies and data quality measures
• Develop, test, install, analyze, upgrade, and maintain data models and processes in an ETL environment
• Provide project estimates, plans, and schedules
• Familiarity with InfoSphere Suite - particularly MDM and Workbench
• Developed ETL programs using Data stage to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Data stage file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other. Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations. Integrated Informatica Data Quality with Informatica Power Center.
• Installed IDQ on an Informatica Power Center server machine.
• Used Informatica Power Exchange& to handle the change data capture data from the source and load into Data Mart by following Slowly Changing Dimensions type II process.
• Involved in modifying existing Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica source and Target Data
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Confidential

Senior ETL/Informatica Datastage Developer

Responsibilities:

• Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Developed complex store procedures using input/output parameters, cursors, views, triggers and complex queries using temp tables and joins.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Creation of jobs sequences.
• Maintained Data Warehouse by loading dimensions and facts as part of project. Also worked for different enhancements in FACT tables.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.
• Coordinate with team members and administer all onsite and offshore work packages.
• Analyze performance and monitor work with capacity planning.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Participated in weekly status meetings.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• ETL job design using DataStage.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications Created complex mappings that involved implementation of Business Logic to load data in to staging area. Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union. Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Write Shell script running workflows in unix environment.
• Optimizing performance tuning at source, target, mapping and session level
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Confidential

Sr ETL Informatica Technical Development Lead

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Part of the Data Integration team for Confidential ’s Human Resources applications that are used by 50,000 people around the world
• Development and support of ETL jobs used by Confidential ’s HR applications
• Schedule of ETL jobs and shell scripts using Cisco Tidal Enterprise Scheduler
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema. Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.
• UNIX Shell scripting

Confidential

Senior ETL Developer

Responsibilities:

• ETL Developer inside Business Intelligence
• Advanced experience on ETL jobs development using Infosphere DataStage
• Experience in Hadoop Hive, creation, manipulation of tables
• Provided guidance to report creators for enhancement opportunities
• Experience on ETL jobs development using Informatica Power Center
• Advanced experience in scheduling ETL jobs using Control M software
• Analyzed business requirements to compose functional and implementable technical data solutions. Identified integration impact to dependent systems, data flows and data stewardship.
• Identified implementation impacts as they affect business processes. Worked with multiple team members technical and business subject experts.
• Produced data models to meet functional data requirements. Data modeling at the enterprise level through to ETL and application.
• Created new data constraints and or leveraged existing constraints for reuse.
• Produced ER diagrams for presentation of requirements and solution review with technical team members, business team members and other leaders and stakeholders.
• Participated JAD session as Data Analyst in expanding existing DB and developing new ones.
• Assisted application developers in creating business requirements and transformed requirements into implementable technical data solutions.
• Perform data flow mapping and create data dictionaries, ensure data integrity from the design standpoint
• Assist in creating High Level and Detailed Design documentation
• Work with Architects to create meaningful requirements for Data Warehouse ETL development
• Work with Data Modelers to perform data analysis, define requirements and data needs
• Support of DataStage ETL jobs
• Support of IPC ETL jobs
• ETL jobs Troubleshooting.

Confidential

SQL Analyst

Responsibilities:

• SQL queries creation to track the production orders.
• Identified manual processing deficiencies, and instituted automation techniques which reduced manual labor and increased work flow efficiency.
• Conferred with internal staff to assure smooth functioning and minimal downtime of newly implemented systems and/or procedures. No negative impact to customers.
• Reduced processing time by analyzing job schedules and implementing approx
• Populating the business rules using mappings into the target tables.
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Worked extensively on modifying and updating existing oracle code including object types, views, PL/SQL stored procedures and packages, functions and triggers based on business requirements.
• Worked in agile minor release cycles the designated database developer.
• Unit test and support QA and UAT testing for database changes.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production.
• Help support Data masking projects for DRD for all Dev, QA and UAT environments via Enterprise Data Obfuscation.
• Build creation, verification and deployment to QA and UAT using Transporter.
• Created batch scripts for automated database build deployment.
• Member of team responsible for making production control.