Sr. Informatica Developer Resume
El Segundo, CA
PROFESSIONAL SUMMARY:
- 7+ years of IT experience in Datawarehousing, Business Intelligence and Informatica developing ETL solutions.
- Have clear understanding of Datawarehousing concepts with emphasis on ETL and life cycle development including requirement analysis, design, development and implementation.
- Very strong knowledge in Informatica Powercenter suite which includes Mapping Designer, Workflow Manager, Workflow Monitor, Admin Console and Repository Manager.
- Extensive working experience in design and development of data warehouse, marts and ODS.
- Handful working experience in Datawarehousing development with data migration, data conversion and extraction/transformation/loading using Informatica Powercenter to extract & load data into relational databases like SQL Server, Oracle, Teradata, DB2.
- Have good debugging skills and Extensive experience in maintenance and production support of Informatica.
- Extensive working experience with Powercenter components of Informatica server and client tools like designer, workflow manager, repository manager and workflow monitor.
- Extensively worked with Informatica mapping variables, mapping parameters and parameter files.
- Worked on various Teradata utilities like MLOAD, FLOAD, FAST EXPORT, TPUMP, TPT.
- Extensively worked with Informatica MDM (Master Data Management) to manage the high - volume data.
- Excellent Hand full working experience in running projects by using scheduling tools like ActiveBatch, TWS, Control-M and AutoSys
- Strong knowledge and understanding of data modeling (Star and snow flake schemes), ER diagrams, Data flow diagrams/Process diagrams.
- Extensive knowledge in optimizing techniques such as concurrent caching, Auto memory calculations, partitioning and using push down optimization.
- Worked with Oracle, Teradata and SQL stored procedures, table partitions, triggers, SQL queries, PL/SQL packages, IBM SQL procedural languages and loading data into data warehouse/data marts using Informatica, DB2 load and SQL loader.
- Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin.
- Developed shell scripts for invoking Informatica workflows and for running batch process.
- Extensive experience in designing the architecture for extract, transformation, load environment and development of mapping and process using Informatica Powercenter.
- Extensive experience in formulating error handling mechanism.
- Excellent analytical skills in understanding client’s organizational structure.
- Good knowledge and experience in Agile and Waterfall methodologies.
- Excellent problem-solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.
TECHNICAL SKILLS:
ETL Tools: Informatica Powercenter 10,9.6.1, 9.5, 9.1.0, 8.x, Informatica MDM, IDQ.
Database: Oracle 9i/10g/11g, SQL Server 2014/2008/2005 and Teradata 14.0, IBM DB2
Data Modeling Tools: Erwin
Scheduling Tools: TWS, Auto Sys, ActiveBatch, Control-M
Languages: SQL, PL/SQL, C, C++
Scripting Languages: Unix Shell scripting
Operating Systems: Windows, Red Hat Linux, Unix
PROFESSIONAL EXPERIENCE:
Confidential, El Segundo, CA
Sr. Informatica Developer
Responsibilities:
- Collaborated with Business People for requirements gathering and Participated in translating the business requirements into technical requirements in agile methodolgy.
- Involved in design and developing the end-to-end ETL process.
- Prepared High-level design document and mapping document according to the business requirements by analysing different data sources.
- Designed and developed mappings in Informatica to load the data into Oracle database.
- Extensively used different transformations such as Source qualifier, look up (connected and unconnected), Expression, Aggregator, Update strategy, Sequence generator, Joiner, Filter, Rank, Normalizer and Router transformations.
- Developed several reusable transformations and mapplets that were used in other mappings.
- Implemented Slowly Changing Dimensions (SCD) Type 1 and Type 2 for initial and history load using Informatica.
- Wrote Unix shell scripts to transfer files from windows servers to Unix server using sftp connections, file validation including checking existence of file, file name check, file size and archiving.
- Developed Informatica mappings to perform file validation (field datatype, length, file count, header etc.) on the files provided by business users and to load those files into the Oracle database.
- Used various Informatica functions in the mappings.
- Wrote SQL stored procedures to extract data and applied transformation logics in the query before loading data into target table.
- Tested Stored procedure stage-by stage and created partitions and indexes on the tables for the better performance of the query.
- Scheduled the workflow using Active Batch and configured the ActiveBatch to send success and failure emails of the jobs to IT support team and business users.
- Performed the unit testing as per the design document and mapping design flow.
- Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
- Prepared the migration document to move the code from Dev to QA environment and then from QA to PROD environment.
- Used Bitbucket and Source tree to push and check-in the code to different environments.
- Involved in resolving the production issues.
- Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
Environment: Informatica Powercenter 10, MS SQL Server 2012, 0racle 11g, UNIX, ActiveBatch 10, Windows.
Confidential, Long Beach, CA
Sr. Informatica Developer
Responsibilities:
- Collaborated with Business People for requirements gathering and Participated in translating the business requirements into technical requirements.
- Involved in design and developing the end-to-end ETL process.
- Designed and developed complex mappings in Informatica to load the data from various sources such as SQL Server, Flat files and loading into Teradata.
- Extensively used different transformations such as Source qualifier, look up (connected and unconnected), Expression, Aggregator, Update strategy, Sequence generator, Joiner, Filter, Rank, Normalizer and Router transformations.
- Developed several reusable transformations and mapplets that were used in other mappings.
- Extracted data from diverse sources like Oracle, SQL Server, COBOL files and Flat Files.
- Used BTEQ, FLOAD, MLOAD, TPT Teradata utilities to export and load data.
- Created a BTEQ script for pre-population of the work tables prior to the main load process.
- Used version mapping to update the Slowly Changing Dimensions to keep full history to the target database.
- Converted workflows with Relational connections to Mload connections to connect to Teradata to reduce overall workflow run-time and to improve the performance.
- Created, configured, scheduled and monitored the sessions and workflows based on run on demand, run on time using Informatica Powercenter Workflow Manager and Workflow Monitor.
- Involved in weekly error tracking and correction process using Informatica.
- Worked with Pre-and-Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power c enter.
- Worked on Informatica Data Quality for Data Profiling, Data Cleansing, Data Validation.
- Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
- Worked with complex queries in SQL for optimization.
- Formatted Reports as per the user requirements using extensive functionalities in SAP Business Objects, which allows the users to analyse the data.
- Perform the unit testing for files using UNIX commands.
- Perform the unit testing as per the design document and mapping design flow.
- Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and databases.
Environment: Informatica Powercenter 9.6.1, IDQ, 0racle 11g, MS SQL Server 2014, TERADATA 14.0, UNIX, Windows.
Confidential, Birmingham, AL
Informatica Developer
- Collaborated with Business People for requirements gathering and Participated in translating the business requirements into technical requirements.
- Involved in effort estimation for the requirements in the project and prepared mapping documents based on client requirement specifications.
- Designed simple and complex mappings using Informatica Powercenter to load the data from source using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy, Normalizer, SQL, Rank and Router transformations into CRDB database (Oracle).
- Extensively used Informatica functions and parameters & variables in the transformations at mapping level.
- Wrote SQL queries for pre-sql and post sql fields in source qualifier transformation with appropriate schema names for extracting only the required rows for optimal performance.
- Tested the queries in SQL navigator for integrity and identifying data errors.
- Used Debugger to fix errors in the mappings and to check the data flow.
- Created sessions, event tasks, decision tasks and workflows using Powercenter.
- Partitioned sessions for concurrent loading of data into the target tables.
- Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
- Developed UNIX Shell Scripts for scheduling the sessions in Informatica.
- Created job schedules using Control-M so that jobs run on 3 rd business day of every month.
- Used Pre session and Post Session to send e-mail to business users through Workflow Manager.
- Created parameter files to change the load date and configured that parameter at session level.
- Used Toad as an advanced SQL, PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions to implement business rules.
- Created scripts to migrate data from CRDB database to CCAR staging area (SQL server) and developed mappings and workflow in staging area.
- Documented ETL test plans, test cases, test scripts, test procedures, assumptions and validations based on design specifications for unit testing and system testing.
- Worked with the QA team to Trouble shoot and resolve any QA or UAT issues.
- Migrated Mappings from Development environment to QA, QA to Production environment.
- Coordinated with the reporting team to develop the MicroStrategy reports.
- Ongoing support has been provided for production issues by looking after the errors in daily loads and played an active role in resolving them .
- Based on the assigned JIRA tickets, added and modified Informatica mappings and sessions to improve performance, accuracy, and maintainability of existing ETL functionality as requested by the users.
- Worked on new column additions to existing target and source tables in ETL as per new business requirements.
- Participated in peer reviews and provided reviewed comments on JIRA.
Environment: Informatica Powercenter 9.6.1, Informatica MDM, SQL Server, Oracle 11g, TOAD, UNIX Shell Scripting, SQL, PL/SQL, MicroStrategy, Control-M.
Confidential, Richardson, TX
Sr. Informatica Developer
Responsibilities:
- Interacted with Business Analyst to understand the requirements and created Business Requirement Specification Document.
- Coordinated with Informatica Administrator/Architect to setup the environment and to move objects to different repositories and folders.
- Involved in Dimensional modeling to Design and develop STAR Schema, Used ER-win to design Fact and Dimension Tables.
- Analysed data sources like Oracle, SQL Server, Flat files including Delimited and Fixed width text files, COBOL files, XML files from which the contract data and billing data is coming and understood the relationships by analysing the OLTP Sources and loaded into Teradata warehouse.
- Used FastLoad and MultiLoad Types to load the bulk data into the Teradata Database Tables and also used Teradata Parallel Transporter (TPT) for loading pipe delimited, comma delimited and fixed-width data files onto Teradata.
- Designed mappings using different transformations like Lookup, Expression, Sorter, Joiner, Router, Union, Transaction Control, Update strategy, Normalizer, Filter, Rank, and Aggregator using Informatica Powercenter designer.
- Developed Index Cache and Data Cache in cache using transformations like Rank, Lookup, Joiner, and aggregator Transformations.
- Developed mapplets to implement the common business logic according to the requirement.
- Worked on Slowly Changing Dimension SCD Type1 and SCD Type2 to maintain customer’s full history.
- Implemented Change Data Capture to extract information and Partitioned sessions for concurrent loading of data into the target tables.
- Created and configured workflows, worklets and sessions using Informatica Workflow Manager.
- Written post SQL and pre SQL at session level.
- Converted workflows with Relational connections to Mload connections to connect to Teradata which drastically reduced the overall workflow run-time and improved the performance.
- Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
- Worked on session log files and workflow log files.
- Extensively worked on Teradata Parallel Transporter (TPT) for data integration from various heterogeneous sources and to eliminate bottlenecks in data load, performed unit testing by generating SQL based on the Test Plans.
- Performed knowledge transfer sessions to Application Development Teams.
- Worked on AutoSys to schedule the jobs and extensively used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.
- Involved in writing shell scripts and added these shell scripts in Cron Job, as scheduled daily, weekly, monthly.
- Identified the task priorities to meet project timelines and project risks and handled multiple work related tasks.
- Documented all ETL related work per company's methodology and maintained standards per business.
- Involved in all migrations of Informatica mappings and DB scripts to QA and Prod.
- Involved in Post production support after delivering the project.
- Worked on agile methodology.
Environment: Informatica Powercenter 9.5, Teradata, SQL Server, Erwin, Oracle 10g, TOAD 9.7, UNIX Shell Scripting, Windows, AutoSys.
Confidential, North Wales, PA
Informatica Developer
Responsibilities:
- Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access and Flat files.
- Used Informatica data services to profile and document the structure and quality of all data.
- Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
- Worked with both connected and unconnected Lookup Transformations.
- Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
- Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
- Used Loader utilities including SQL Loader and Teradata utilities (FASTLOAD, FASTEXPORT, and MULTILOAD).
- Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.
- Used Debugger wizard to troubleshoot data and error conditions.
- Responsible for Best Practices like naming conventions, and Performance Tuning.
- Developed Reusable Transformations and Reusable Mapplets.
- Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
- Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
- Worked with Shortcuts across shared and non-shared folders.
- Responsible for migrating the code using deployment groups across various Instances.
- Optimized SQL queries for better performance.
- Created PRE-SQL and POST-SQL scripts which need to be run at Informatica level.
- Responsible for Unit Testing of Mappings and Workflows.
- Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
- Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
- Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
- Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
Environment: Informatica Powercenter 9.0.1, Oracle 11i, Teradata, SQL server, SQL/PLSQL, UNIX shell scripting, Windows.
Confidential
ETL/SQL Developer
Responsibilities:
- Created dimensional model for the reporting system by identifying required dimensions.
- Populated the business rules using mappings into the Repository for Data management.
- Designed Sources to Targets mapping from primarily Flat files to Oracle using Informatica Powercenter.
- Created global repository, Groups, Users and assigned privileges using repository manager.
- Involved in developing source to target mappings and scheduling Informatica sessions.
- Various kinds of the transformations were used to implement simple and complex business logic. Transformations used were: connected & unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence generator, etc.
- Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences etc.,
- Tuned Informatica Mappings and Sessions for optimum performance.
- Worked in writing UNIX scripts, SQL statements and interacted with development and production teams to expedite the process.
- Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions.
Environment: Informatica Powercenter, Oracle 8i, SQL Server 2000, SQL, PL/SQL.