We provide IT Staff Augmentation Services!

Team Lead Resume

PROFESSIONAL SUMMARY:

  • 10+ years of IT professional experience in designing, analysis, programming and testing using Informatica Power Center 10.x/9.x/8.x as a developer and Administrator .
  • Extensive experience in design, development and implementation of Data marts, Enterprise Data Warehouses and Business Intelligence Solutions.
  • Extensive experience in data migration, integration and Data archiving applications.
  • Extensive experience in handling Legacy applications data and moving the data into archiving database.
  • Handled data extraction from ERP systems like People soft and SAP
  • Extensive experience in Insurance, Financial and Healthcare domains.
  • Experience with setting up access roles and privileges, code page setups, appropriate ETL migration activities.
  • Experience in creating repository and integration services and managing them in grid environment.
  • Handling the Informatica repository backups/restore tasks.
  • Experience in handling all Informatica Admin activities .
  • Mentored and monitored offshore and onsite development teams with regular calls on the commonly raised issues and propose permanent fixes.
  • Participated in design and code reviews with managers, peers and involved business personnel.
  • Worked with QA personnel to develop and carry out test plans to ensure that Data Warehouse/Mart and ETL BI solutions are of the highest possible quality.
  • Responsible for all activities related to the development, implementation, administration and support of ETL processes for large - scale data warehouses.
  • Expertise in tuning mappings, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions.
  • Extensive experience in UNIX shells scripting .
  • Hands on experience in scheduling jobs through Control-M .
  • Very good exposure to Oracle, SQL Server and Db2.
  • Extensive experience in writing complex queries in SQL and developing objects in PL SQL (Stored procs, functions and triggers) for different DWH project requirements.

TECHNICAL SUMMARY:

Informatica: Power Center 10.2/9.X/8.X

Programming: SQL, PL/SQL, UNIX Shell Scripting.

Scheduling Tools: Control M, WLM, Crontab

DB Utilities: TOAD, SQL Developer, SQL Server Management Studio, IBM Data Studio

Databases: Oracle, SQL Server and DB2

BI/Reporting Tools.: OBIEE and Business Objects

Environment: AIX, HP - UX, RHEL, Windows

Methodologies: Star Schema, Snow Flake Schema and Agile

File Transfer Methods: FTP, SFTP and SCP

Other: SSH, CoreFTP, Win SCP, Putty.

WORK EXPERIENCE:

Confidential

Team Lead

Responsibilities:

  • Validating the source feeds sent by the various source systems.
  • Taking care of incremental loads by creating the parameter files dynamically on regular basis.
  • Maintaining audit tables to make sure all the source data is loaded into target without any data discrepancies and to maintain smooth execution of all the loads.
  • Working with different source teams to setup FTP/SFTP process and to define source file structures.
  • Creating shell scripts for various requirements to fulfill project requirements.
  • Creating stored procedures for different requirements.
  • Execute test plans, debug and apply subsequent fixes.
  • Identify and evaluate risks and participate in mitigation and control activities.
  • Taking responsibility of creating and maintaining project documentation.
  • Identifying and fixing bottlenecks and tuning the complex mappings for better Performance.
  • Taking care of code reviews, unit testing, Integration testing and system testing.
  • Scheduling jobs using Control M and Crontab and migrating the code from lower environment to higher environment.
  • Work in an Agile environment and adapt to the changing needs and requirements of the business.
  • Taking care of history loads and providing the production support.
  • Root cause analysis of job abends and providing permanent fixes as per SLA.
  • Communicating with the clients on a regular basis to make sure all the tasks are progressing as per the timelines.
  • Assigning the requirements to offshore and onshore team members and helping them on providing high level business logic.

Environment: Informatica 10.2, IBM DB2, SQL Server 2012, Oracle 12C, Business Objects, Service Now, Flat Files, PL/SQL and UNIX.

Confidential

Team Lead

Responsibilities:

  • Responsible for Requirement Gathering, Project Co-ordination and Analysis of source data
  • Translated business rules and functionality requirements into ETL procedures
  • Implemented extraction/transformation/load (ETL) interfaces to facilitate transitioning from old legacy Salesforce systems to Oracle systems.
  • All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
  • Implemented best practices in ETL Design and development and ability to load data into highly de-normalized tables and Kimball Methodology.
  • Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
  • Conduct source System Analysis and developed ETL design document to meet business requirements.
  • Developed Informatica Mappings and Workflows to extract data from PeopleSoft, Oracle, CSV files to load into DWH.
  • Designed and developed custom Data Quality audits to identify and report the data mismatch between source and target systems and alert Operations Team.
  • Tuned Teradata SQL queries and resolved performance issues due to Data Skew and Spool space issues.
  • Developed Flat files from Teradata using fast export, Bteq to disseminate to downstream dependent systems.
  • Coordinated with the offshore project team members on daily basis for the continuation of tasks and resolving any issues.
  • Supported System Integration and User acceptance tests to obtain sign off.
  • Post go live Production Support and Knowledge Transfer to Production Support team
  • Worked extensively on Informatica Partitioning when dealing with huge volumes of data to optimize the performance of mappings.
  • Prepared unit and integration test plans, code review, testing, debugging, deployment of Informatica Jobs into production environment.
  • Worked extensively on SQL, PL/SQL and UNIX Shell Scripts.
  • Provided support and quality validation thru test cases for all stages Unit and Integration testing.
  • Provided end user training and Production System Support.

Environment: Informatica Power Center 9.1, Business Objects, Teradata V2R6/12, Oracle 9i/10g, Windows XP, UNIX, LINUX.

Confidential

Sr Informatica Developer

Responsibilities:

  • Implemented near real time data warehousing solution. Informatica Power Exchange has been used to read the Oracle database logs to capture the changes in the data. The changes are then propagated to a staging area through a “Pull” mechanism using Informatica Power Centre & Power Exchange connector.
  • Involved in designing and developing logical & physical data models using Erwin to support the operational reporting applications.
  • Performed peer code reviews to ensure compliance with ETL standards.
  • Enhanced system performance by optimizing and tuning database objects, reports and ETL processes and handles Netezza.
  • Assisted the team members in designing & developing ETL mappings and workflows.
  • Tuned Existing Oracle scripts for better performance.
  • Coded SQL Scripts to create the Development Database, Testing Database, Production Database, including Tablespaces, added datafiles to tablespaces, managed control files, Rollback segments creation, Users, Synonyms, Roles, profiles, Privileges.
  • Developing the Informatica mappings, executing sessions, and validating the results.
  • Developed SQL and PL/SQL codes for various procedures, functions, and packages to implement the business logics in an Oracle database.
  • Managed Metadata associated with Informatica. Queried the metadata for reporting purposes.
  • Worked on the complete Life cycle of Business Intelligence project with focus on Extraction, Transformation and Loading of data using Informatica Power Center.
  • Developed several complex Oracle Scripts.
  • Strong in using workflow tasks like Session, Control Task, Command tasks, Decision tasks, Event wait, Email tasks, Pre-sessions, Post-sessions and Pre/Post commands.
  • Created, updated and maintained technical documentation, Unit Test plans and release notes.
  • Worked as a backup Admin, handled production support issues and resolved issues during Project deployment.

Environment: Informatica Power Center 8.6/9.1, Oracle11g, UNIX, Windows 2000/XP, Quality Centre & Toad.

Confidential

Sr Informatica Developer

Responsibilities:

  • Extensively used Informatica to load data from sources involving SQL Server and Flat files to DB2 databases.
  • Involved in the Extraction, Transformation and loading of the data from various sources into the dimensions and the fact tables in the Data Warehouse.
  • Created reusable Transformations and Mapplets and used them in various mappings.
  • Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
  • Created Informatica mappings with PL/SQL procedures to build business rules to load data.
  • Most of the transformations were used like the Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence.
  • Assisted in Generating reports using the report-generating tool, Business Objects.
  • Created and scheduled Sessions and Batch Process based on demand, run on time, or run only once using Informatica Workflow Manager and monitoring the data loads using the Workflow Monitor
  • Participated in Testing and performance tuning by identifying bottlenecks in mapping logic and resolving them, setting cache values and creating partitions for parallel processing of data
  • Developed Reports in Cognos Impromptu and Power play

Environment: Oracle 9i, SQL Server 2000, PL/SQL, Informatica Power Center 8.1, Erwin, Cognos, Windows NT/2000, UNIX

Confidential

Informatica Developer

Responsibilities:

  • Interacted with business community and gathered requirements based on changing needs and incorporated identified factors into Informatica mappings to build Data Marts.
  • Extensively worked on Power Center Designer to develop mappings using several transformations such as Filter, Joiner, Lookup, Rank, Sequence Generator, Aggregator and Expression transformations.
  • Implemented Type 1 and Type 2 Slowly Changing Dimensions.
  • Created parameter files and used mapping parameters and variables for incremental loading of data.
  • Involved in performance Tuning of Transformations, mappings, and Sessions for better performance.
  • Generated test plans and performed unit testing.
  • Involved in developing the Tables, Views, Stored Procedures, Materialized views and Indexes.
  • Created reusable Transformations and Mapplets and used them in various mappings.
  • Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
  • Created Informatica mappings with PL/SQL procedures to build business rules to load data.
  • Most of the transformations were used like the Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence.
  • Assisted in Generating reports using the report-generating tool, Business Objects 6.0

Environment: Informatica 8.6, Business Objects XI, Oracle 11g, SQL Server 2005, Flat files, SQL, PL/SQL, Windows NT.

Confidential

ETL Developer

Responsibilities:

  • Interacted with business analysts and translate business requirements into technical specifications.
  • Designed and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
  • Extensively worked on Informatica to extract data from Flat files, Excel files, and MS Access database to load the data into the target database.
  • Implemented the Incremental loading of Dimension and Fact tables.
  • Created Tasks, Workflows and Sessions to move the data at specific intervals on demand using Workflow Manager.
  • Developed the control files to load various sales data into the system via SQL*Loader.
  • Developed Unix Shell scripts for maintaining Files and to run Informatica jobs.
  • Designed and created an Autosys job plan to schedule our processes.
  • Developed, tested and implemented break/fix change tickets for maintenance.
  • Involved in writing test cases, assisting Testing team in testing.
  • Developed the document of the complete ETL process.
  • Created UNIX Shell scripts and PL/SQL Scripts to automate UNIX and database activities.
  • Worked on Performance Tuning of Various mappings and sessions to identify and remove bottlenecks.

Environment: Informatica Power Center 7.1.3, TOAD, Oracle 8i (SQL/PLSQL), MS Access 2006, Win 2000, Autosys, MS Excel 2006, UNIX, UNIX Shell Script.

Confidential

ETL Developer

Responsibilities:

  • Analyzed business requirements, performed Impact Analysis, created technical design specifications, developed code, performed Code Deployment, and provided production support.
  • Developed various transformations like Source Qualifier, Update Strategy, Lookup & Expression transformation, Expressions and Sequence Generator for loading the data into target table.
  • Implemented the Change data capture (CDC) using the Informatica Power Exchange.
  • Extracted the data from SAP ECC and BW system’s and loaded the data into ODS tables.
  • Improved performance by using Explain Plan, Creating appropriate indexes, queries optimization, utilizing table spaces and partitioning schemes.
  • Responsible for identifying the missed records in different stages from source to target and resolving the issues.
  • Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.
  • Worked closely with database administrators and application development team(s) on the design and implementation of the database.
  • Creating users, folders and assigning the read, write and execute permissions.
  • Performed quality assurance testing of data integration and report development. Monitored data load operations to ensure accuracy.

Environment: Oracle 10G, PL/SQL, SQL, SQL Loader, XML, Flat files, Windows NT, HP-UX, Shell Scripting

Hire Now