We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

Tampa, FL

SUMMARY

  • 7 years of IT experience in Analysis, Design, Development, Testing, Implementation and Support of Data Integration Data Migration Projects using Informatica Power Center & Informatica Cloud (IICS).
  • Experienced in working with various relational data bases like Oracle, Teradata, Db2, My Sql and SQL server also used Sales Force & SnowFlake.
  • Extensive experience in ETL (Extraction, Transformation and Loading) of data using Informatica Power Center from heterogeneous sources like Flat files (Fixed width, delimited), XML files, Relational databases.
  • Extensive knowledge in SDLC (Software Development Life Cycle) and executed projects in Waterfall and Agile methodologies.
  • Strong understanding of Dimensional Modeling, Star, Snowflake Schema, OLAP and DW concepts.
  • Extensive knowledge in RDBMS concepts and Relational and Dimensional Data modeling.
  • Worked closely with the data stewards to get data quality project requirements.
  • Experienced in understanding the Project scope, Dependencies, Risks and provide estimations.
  • Experienced in coordinating and leading onsite - offshore development model.
  • Created complex mappings using transformations like Source qualifier, Expression, Aggregator, Joiner, Look up, Normalizer, SQL, Union, Update strategy, Stored Procedure, Filter, Router, XML Generator and Parser, Java Transformations.
  • Co-ordinated guided and leads the teams effectively in technology migration from Informatica 9.6.1 to 10.2.
  • Created Informatica Cloud mappings using Data Replication Task, Data Synchronization Task & Mapping Task.
  • Migrated Power Center Mappings to Cloud using Power Center Task.
  • Used Mass Ingestion Task to do heavy loads in Cloud.
  • Created several Cloud mappings as part of POC to extract and load the data into snowflake.
  • Experienced with Teradata utilities like BTEQ, M-LOAD, F-LOAD, F-EXPORT, T-PUMP & TPT and populate Teradata database tables.
  • Expertise in analyzing the source data systems for better understanding the business requirements, designing optimal ETL design.
  • Developed technical specifications of the ETL process flow, High level and Low-Level Design and Source to Target mapping documents.
  • Designed and Developed Audit, Control and balancing process.
  • Strong experience in handling Slowly Changing Dimensions (SCD) and Change Data Capture (CDC).
  • Experience with Informatica Advanced Techniques - pushdown optimization, session partitioning.
  • Extensively involved in creating reusable objects to standardize Informatica code and to bring down the development and testing efforts.
  • Expertise in developing the flexible ETL code for maintenance and future enhancements by adopting parameterization.
  • Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks at Source, Transformations, Target layers.
  • Experienced in setting up Shared Informatica infrastructure and UNIX platform in co-ordination with Infrastructure partner team.
  • Extensively involved in writing Unix Shell Scripting programs like Source file validations, Files upload/Download to/from remote server, Source/Target Files Archival/purge requirements and to run ETL batch jobs from UNIX using PMCMD command.
  • Experienced in scheduling of ETL jobs using diff scheduling tools Maestro, Autosys, Control-M.
  • Independently perform complex troubleshooting, root-cause analysis and provide solution to fix defects.
  • Experienced in writing sql queries using OLAP functions to improve the performance of the queries.
  • Experienced in creating and using Stored Procedures, Functions, Views and Materialized views.
  • Extensively involved right from Project engagement to till Production Warranty support of the project.
  • Prepared Project support handover document and transitioned to Support team to ensure smooth execution of the project in Production.
  • Generated warning and Error reports and shared with Business users to further analysis.
  • Supported and guided Testing and Business users while SIT, UAT in progress and obtained sign off from SIT, UAT Teams.
  • Extensively involved in generating automated alerts to Business users and Email notifications as per Business requirement.
  • 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.

TECHNICAL SKILLS

ETL: Informatica Power Center 10.2/ 9.6.1/9.5.1 /9.1.1/8.6.1 , IICS(Cloud)

Database: Oracle, IBM DB2, Sql Server, Teradata, My Sql, Sales Force, Snowflake

Tools: TOAD, SQL developer, Sql Assistant, Rally, Service Now

Languages: SQL, PL/SQL, Java, Unix Shell Scripting

Operating Systems: Windows, Linux, Unix

Data modeling tools: Erwin, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr. Informatica Developer

Responsibilities:

  • Worked closely with the business teams to understand the requirements along with Business Analyst & ETL Team.
  • Involved in the discussions with data modelers to review the design of the data model and to create database tables.
  • Involved the in creating the technical design documents along with Business Analyst and design walk through with data architects.
  • Developed the informatica mappings using Source Qualifier, Expression, Joiner, Look up, Sql, Router, Union, Normalizer, Stored Procedure transformations.
  • Provided informatica training to team and guided them as and when necessary.
  • Extracted data from various sources Oracle, My Sql, Flat Files and loaded into Teradata.
  • Used Teradata BTEQs to load data from staging to base database.
  • Used Teradata Utilities - M-Load, F-Load, F-Export, T-Pump & TPT both at scripting level and along with Informatica connection.
  • Involved in doing performance tuning (Using Explain Plan) of long running Teradata BTEQs in prod environment as part of the support team.
  • Generated error and warning reports to help business teams for further analysis of data.
  • Tuned Informatica mappings to increase the through put using various performance tuning techniques.
  • Created reusable objects /mapplets to standardize Informatica code and to bring down the development and testing efforts.
  • Created store procedures, Functions, Views as part of the business logic implementation.
  • Reviewing the Code during Peer review which is developed by the team members and provided feedback.
  • Involved in test data preparation for SIT, UAT phases.
  • Created Informatica Cloud mappings using Data Replication Task, Data Synchronization Task & Mapping Task.
  • Migrated Power Center Mappings to Cloud using Power Center Task.
  • Used Mass Ingestion Task to do heavy loads in Cloud.
  • Created several Cloud mappings as part of POC to extract and load the data into snowflake.
  • Involved in Deploying the Informatica code to test and production environments.
  • Provided estimations for the ETL Tasks.
  • Participated in daily stand up calls and kick off meeting sessions at the begin of each iteration and Retrospective meetings.
  • Worked with the Scheduling/Operations teams for scheduling the ETL jobs in Maestro.
  • Supported ETL Prod environment during warranty phase using trouble tickets.

Environment: Informatica Power Center 10.2, Informatica Cloud (IICS), Oracle, My Sql, Flat Files, Sales force, Snow Flake, Teradata 16/15, Linux, Perl, TOAD, Teradata SQL Assistant, WinSCP, Putty, Rally.

Confidential, San Antonio, TX

Sr. Informatica Developer & Data Analyst

Responsibilities:

  • Developed internal and external Interfaces to send the data in regular intervals to Data warehouse systems.
  • Extensively used Power Center to design multiple mappings with embedded business logic.
  • Involved in discussion of user and business requirements with business team.
  • Performed data migration in different sites on regular basis.
  • Involved in upgrade of Informatica from 9.5.1 to 9.6.1.
  • Created complex mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target tables in efficient manner.
  • Attended the meetings with business integrators to discuss in-depth analysis of design level issues.
  • Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development.
  • Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using Parameter files.
  • Developed complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements and extensively used Teradata Utilities like M - load, F- Load, TPT, BTEQ and Fast Export.
  • Analyzed session log files in session failures to resolve errors in mapping or session configuration.
  • Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating the execution of maps.
  • Created transformations like Expression, Lookup, Joiner, Rank, Update Strategy and Source Qualifier Transformation using the Informatica designer.
  • Created mapplet and used them in different mappings.
  • Worked on Flat Files and XML, DB2, Oracle as sources.
  • Written PL/SQL Procedures and functions and involved in change data capture (CDC) ETL process.
  • Implemented Slowly Changing Dimension Type II for different Dimensions.
  • Involved in Informatica, Teradata and oracle upgrade process and testing the environment while up gradation.
  • Worked with Informatica version Control excessively.
  • Experience in using SVN as version control for migration.
  • Written Unit test scripts to test the developed interfaces.
  • Managed enhancements and coordinated with every release with in Informatica objects.
  • Provided support for the production department in handling the data warehouse.
  • Worked under Agile methodology and used Rally tool one to track the tasks.
  • Written thorough design docs, unit test documentation, Installation, and configuration guide documents.
  • Performed bulk data imports and created stored procedures, functions, views, and queries.

Environment: Informatica Power Center 9.6.1/9.5.1 , Oracle 10g, DB2, Flat Files, XML, Teradata 14/12, Unix/Linux, TOAD, Teradata SQL Assistant, WinSCP, Putty, SVN, Rally.

Hire Now