We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

0/5 (Submit Your Rating)

Atlanta, GA

SUMMARY

  • Over 5 years of strong Data Warehousing experience in analysis, design, development and implementing software solutions in various business applications with ETL/Informatica Power Center 9.0.1/8.x/7.
  • 2.5 year of real - time data Warehouse development experience using CDC tool Informatica Power exchange 9.0/8.6
  • Extensively worked with various components of the Informatica Power Center - Power Center Designer(Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Repository Manager, Workflow Manager, and Workflow Monitor to create mappings for the extraction of data from various source systems.
  • Good knowledge of business/process dataflow in organizations and proficient in data modeling using ERWIN.
  • Experience in implementing complex business rules by creating re-usable transformations, and robust mappings/mapplets using different transformations like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure, Normalizer etc.
  • Proficient in full life cycle development of Data Warehousing, ETL strategies, reporting and hands on experience in Performance Tuning of sources, targets, transformations, mappings and sessions using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
  • Extensive experience in integrating data from various Heterogeneous sources like Relational database (Oracle, SQL Server, Teradata, DB2), Flat Files (Fixed Width and Delimited), COBOL files, XML Files and Excel files into Data Warehouse and Data Mart.
  • Experience in Database Design, Entity-Relationship modeling, Dimensional modeling like Star schema and Snowflake schema, Fact and Dimension tables.
  • Worked with Slowly Changing Dimensions type 1 and type 2.
  • Experience in Oracle PL/SQL Programming (Stored procedures, Triggers, Functions, Packages) and UNIX shell scripting to perform job scheduling.
  • Worked with Teradata loading utilities like Multi Load, Fast Load, TPump and BTEQ.
  • Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
  • Demonstrated ability to take initiatives, grasp and expand on ideas, tackle and follow through difficult assignments in the fast-pace and changing environment.
  • Independent yet team oriented with excellent analytical, problem solving, multi-tasking, oral and written communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.1.5/8.6.1

CDC tool: Informatica PowerExchange 9.1.5/8.6

Databases: Oracle 11g/10g/9i/8i, DB2, MS SQL Server 2008/2005, Teradata 13/V2R6, SQL Server 2008/2000.

Data Modeling tools: ERWIN 4.x, MS Visio

Languages: SQL, PL/SQL, UNIX Shell scripts, C, C++, Java, VB Script

Development Tools: SQL *Plus, TOAD, SQL Navigator, SQL Developer

Reporting Tools: Business Objects XI, OBIEE 10g.

Scheduling Tools: Autosys, Tidal

Packages: MS Word, MS Excel, MS Visio, MS PowerPoint

Operating Systems: Sun Solaris, UNIX, LINUX, MS-DOS

Processes/Methodologies: Agile Software development, Scrum/Sprint, Pair programming.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Informatica Developer

Responsibilities:

  • Worked with business analyst for requirement gathering, business analysis, and testing and project- coordination.
  • Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
  • Analyzed the mapping logic to determine the reusability of the code.
  • Handled versioning and dependencies in Informatica.
  • Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
  • Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
  • Configured Informatica Power Exchange connection and navigator.
  • Created Registration, DataMap, configured Real-Time mapping and workflows for real-time data processing using CDC option of Informatica PowerExchange.
  • Wrote Script to load multiple tables and used MLOAD utility.
  • Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
  • Performing ETL & database code migrations across environments.
  • Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
  • 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 and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
  • Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test & supported the UAT for the client.

Environment: Informatica PowerCenter 9.1.5, Informatica PowerExchange 9.1.5, Toad, UNIX Shell Scripting, Oracle Exadata, SQL Server 2008, Teradata 13, Mercury Quality Center, Autosys, Linux.

Confidential, Michigan

ETL/Informatica/SQL Developer

Responsibilities:

  • Analyzed source data for potential data quality issues and addressing these issues in ETL procedures.
  • Developed technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules.
  • Design, develop, test, maintain and organize complex Informatica mappings, sessions and workflows.
  • Translated the PL/SQL logic into Informatica mappings.
  • Provided support for existing systems and worked on new development initiatives simultaneously.
  • Actively participate in design and analysis sessions to ensure sound team decision-making.
  • Support system and user acceptance testing activities, including issue resolution.
  • Complete technical documentation to ensure system is fully documented.
  • Design and develop ETL using CDC using Power Exchange 8.6 in Mainframe DB2 environment.
  • Created registration and data map for mainframe source.
  • Created restart token for various workflows.
  • Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy.
  • Investigated current system, created requirements for new user management application
  • Created application for migrating data between system/database using PHP, MYSQL
  • Attended weekly meetings and discussed about the future goals
  • Learned valuable communication and developing skills by working with other developers and administrators.
  • Experience in writing SQL, PL/SQL codes, stored procedures and packages.
  • Experience in full and partial push down optimization.
  • Worked on Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Slowly Changing Dimensions, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.

Environment: Informatica PowerCenter 8.6, PowerExchange 8.6, SQL Server 2008, Teradata V2R5, UNIX, Toad, Harvest, Sun Solaris and Erwin7.5, OBIEE 10g.

Confidential, IN

Informatica Developer

Responsibilities:

  • Designed ETL processes using Informatica to load data from Flat Files, and Excel files to target Oracle Data Warehouse database
  • Performed data manipulations using various Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator, Stored Procedure etc.,
  • Used tuned SQL overrides in source Qualifier to meet business requirements
  • Written pre session and post session scripts in mappings.
  • Created sessions and workflows for designed mappings. Redesigned some of the existing mappings in the system to meet new functionality
  • Created and used different reusable tasks like command and email tasks for session status
  • Used Workflow Manager to create Sessions and scheduled them to run at specified time with required frequency
  • Monitored and configured the sessions that are running, scheduled, completed and failed.
  • Created test case, participate in System integration test, UAT and migrated code from Dev to Test to QA to Prod.
  • Compiled report presentations using tools like Bussiness Object reports.
  • Involved in writing UNIX shell scripts for Informatica ETL tool to fire off services and sessions

Environment: Informatica PowerCenter 8.6, Oracle 10g/9i, Flat files, Excel, SQL Server, PL/SQL, Toad, UNIX Shell Scripting, Windows XP, Bussiness Object XI R2.

Confidential, Birmingham, Al

ETL/ Informatica Developer

Responsibilities:

  • As a team member i involved in collecting all the requirements for building the database.
  • Involved in Creation and designed required tables, indexes and constraints. for all activities.
  • Played a key role in designing the application and migrate the existing data from relational sources to corporate warehouse effectively by using Informatica Power center.
  • Responsible for Extracting, Transforming and Loading data from Oracle, Flat files and placing them into targets.
  • Developed various mappings using Mapping Designer and worked with Source qualifier, aggregator, connected unconnected lookups, Filter transformation, and sequence generator transformations.
  • Involved in Data Modelling and design of Data Warehouse and Data Marts in Star Schema methodology with conformed and granular dimensions and fact tables.
  • Designed and developed UNIX Shell scripts to report job failure alerts.Worked with Data Quality group to identify and research data quality issues.
  • Coding, Debugging and sorting the time-to-time technical problems.
  • Extensive experience in Performance Tuning -Identified and fixed bottlenecksand tuned the complex Informatica mappings for better Performance.
  • Involved in Unit testing, System testing and UAT to check data consistency.
  • Scheduled Informatica Jobs through Autosys scheduling Tool.
  • Involved in designing the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) in Oracle as per business requirements using ERWin.
  • Extensive experience in Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL.
  • Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.

Environment: Informatica PowerCenter 8.1, Oracle 10g, SQL Server (7.0), SQL, Sybase, PL/SQL, Erwin, UNIX, Windows XP.

Confidential, Edgewood, NY

ETL/ Informatica Developer

Responsibilities:

  • Involved in identification of facts, measures, dimensions and hierarchies for the DM model.
  • Analysed Source System data. Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformation designer.
  • Imported data from various Sources (Oracle, fixed width flat files, XML), transformed and loaded into Targets using Informatica.
  • Used Teradata Special Loads like Tpump, Mload, and FastLoad.
  • Created Stored Procedures to transform the Data and worked extensively on PL/SQL for various needs of the transformations while loading the data.
  • Tuned mappings, transformations and recommended tuning options of source/target database to DBA team for obtaining optimum performance.
  • Created Universe & the Business Objects Reports using the universe as the main Data provider and writing the complex queries including Sub queries, Unions, Intersect and Aliases using Business Objects features like Slice and Dice, Drill Down, and Formulae.
  • Created Mapplet and used them in different Mappings.
  • Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
  • Used Informatica Server manager to create Sessions and Workflows to run with the logic embedded in the mappings.
  • Performancetuning of the Informatica mappings using various components like Parameter files, variables and dynamic Cache.
  • Involved in Documentation regarding the ETLprocess.
  • Coordinated with offshore site in developing and deploying mappings.
  • Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
  • Created database tables, indexes in OracleDatabase by implementing various business rules using appropriate constraints and database triggers.

Environment: Informatica PowerCenter 8.1, Informatica Server Manager, Informatica Repository Manager, Workflow manager, Workflow monitor, Oracle 9i, Erwin 4.1, SQL 2005/2000, Flat Files, Windows XP.

We'd love your feedback!