We provide IT Staff Augmentation Services!

Sr. Informatica/etl Developer Resume

Plano, TexaS

SUMMARY:

  • Over Eight years of business applications development and data processing experience with skills in Client/Server database applications design (data analysis and data modeling).
  • 7 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, development (programming, analysis and testing), implementation, tuning, and maintenance.
  • 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.
  • Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
  • Expertise in performance tuning of Informatica mappings and sessions for better performance.
  • Strong experience with UNIX Shell Scripting, PL/SQL, Oracle tuning as part of partitioned tables and B-Tree indexes and optimizing the SQL to improve the performances.
  • Excellent comprehension of Data Warehousing concepts like dimensional modeling, star schema, snowflake schema, ETL, serial and parallel processing.
  • Solid understanding of Data Warehousing life cycle and strong working experience on Data Warehousing applications.
  • Extensive database experience using Oracle 11g/10g/9i/, Teradata and MS SQL Server 2000.
  • Expert in writing optimized PL/SQL, SQL in Oracle 9i/10g/11g. Expertise in performance tuning of SQL queries.
  • Designed and Developed Web-based applications using J2EE Technologies and ColdFusion.
  • Involved in all phases of the software development life cycle.
  • Excellent Interpersonal and communication skills. Quick learner in new technologies.
  • 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:

Operating Systems: UNIX, Linux, SUN-OS, VMS, Windows NT/2000/Xp

Programming Languages: JAVA, SWING, XML, Java Script, HTML, C, C++, SQL*plus, PL/SQL, Pro*C, Basic, Shell programming

Databases: Oracle 10g/11g, SQL Server 2000, Sybase, Teradata 13/14, DB2 and Netezza.

Data Warehousing: Informatica PowerCenter 9.5/8.6.1, Informatica PowerExchange 9.5/9.1/8.6, IDQ, IBM Data Stage (Designer, Sequencer)

Software: WebSphere Studio Application Developer 5.x, Sun One Studio, MacroMedia DreamWeaver3.0, ColdFusion, SQL Navigator, Tableau, Toad, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Plano, Texas

Sr. Informatica/ETL Developer

Responsibilities:

  • Responsible for gathering and analyzing the requirements and translate business requirements to architect ETL solutions for implementation by developer teams.
  • Responsible for managing ETL team of developers both onsite and offshore.
  • Involved in creating high Level Design document and Detail Design document.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Developed several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter to load into staging tables and then to Dimensions and Facts.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment and scheduling of the workflow.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
  • Extensive experience in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Developed and executed UNIX scripts as pre/post-session commands to FTP the data files.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Participated in peer code reviews to make sure that coding standards are followed and provided direction to the developers when needed.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica PowerCenter 9.5, Informatica PowerExchange 9.5, Tableau, IDQ, Oracle 11g, SQL, SQL*Plus, TOAD 9.0, CDC, Teradata 14, Java, HTML, C++, WebSphere, Linux.

Confidential, Norman, OK

Sr. Informatica /ETL Developer

Responsibilities:

  • Responsible for gathering and analyzing the requirements and translate business requirements to architect ETL solutions for implementation by developer teams.
  • Responsible for managing ETL team of developers both onsite and offshore.
  • Involved in creating high Level Design document and Detail Design document.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Developed several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter to load into staging tables and then to Dimensions and Facts.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment and scheduling of the workflow.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Developed and executed UNIX scripts as pre/post-session commands to FTP the data files.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Participated in peer code reviews to make sure that coding standards are followed and provided direction to the developers when needed.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica PowerCenter 9.5, Informtica PowerExchange 9.5, IDQ, Oracle 11g, SQL, SQL*Plus, TOAD 9.0, CDC, Teradata 14, Java, HTML, C++, Erwin 7.1, WebSphere, ColdFusion, Linux.

Confidential, Redwood City, CA

Informatica/ETL Senior Developer

Responsibilities:

  • Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data mart.
  • Involved in creating high Level Design document and Detail Design document.
  • Lead ETL team involved in Informatica implementation and support.
  • Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin.
  • Extracted data from different sources like Oracle and flat files using ETL tool.
  • Worked on Informatica components Repository Manager, PowerCenter Designer, Workflow Manager and Workflow Monitor.
  • Developed mappings and mapplets using Informatica Designer tools - Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer.
  • Developed several complex mappings in Informatica using PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files using Informatica PowerCenter.
  • Used various transformations like Connected and Unconnected Look up, Router, Sorter, Filter, Union, Stored procedure, Source Qualifier, Java, Aggregator and Update Strategy transformations to implement complex business logic.
  • Created Sessions, workflows using Workflow Manager.
  • Used Workflow Monitor to monitor the workflow status.
  • Involved in tuning Mappings and Sessions to improve performance.
  • Developed Perl scripts to automate data load process, create/manage partitions and sub partitions dynamically based on the source data and execute the Informatica workflows. Used Perl’s DBI interface to access databases directly.
  • Used Appworx for scheduling the jobs.

Environment: Informatica PowerCenter 9.1, Oracle 11g, SQL, SQL*Plus, IDQ, B2B, Business Objects, CDC, Teradata 13, TOAD 9.0, Erwin 7.1, Linux.

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 Modeling 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 bottle enecksand tuned the complex Informatica mappings for better Performance.
  • Involved in Unit testing, System testing and UAT to check data consistency.
  • Schedule Informatica Jobs through Autosys scheduling Tools.
  • 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.6, Informtica PowerExchange 8.6, Oracle 11g, SQL Server (7.0), SQL, Sybase, PL/SQL, Erwin, UNIX, Windows XP.

Confidential, Grand Rapids, MI

ETL Consultant

Responsibilities:

  • Involved in creation of Logical Data Model for ETL mapping and the process flow diagrams.
  • Worked with SQL developer to write the SQL code for data manipulation.
  • Worked on Informatica versioned repository with check in and checkout objects feature.
  • Used Debugger extensively to validate the mappings and gain troubleshooting information about data and error conditions.
  • Provided guidance to less experienced personnel. Conducted quality assurance activities such as peer reviews.
  • Participate in the business analysis process and the development of ETL requirements specifications.
  • Worked with production support systems that required immediate support
  • Develop, execute and maintain appropriate ETL development best practices and procedures.
  • Assisted in the development of test plans for assigned projects.
  • Monitor and tune ETL processes for performance improvements; identify, research, and resolve data warehouse load issues.
  • Involved in unit testing of the mapping and SQL code.
  • Developed mappings to load data in slowly changing dimensions.
  • Involved in performance tuning of source & target, mappings, sessions and workflows.
  • Worked with connected, unconnected lookups and reusable transformations and mapplets.
  • Utilized Unix Shell Scripts for adding the header to the flat file targets.
  • Involved in designing the star schema and populating the fact table and associated dimension tables.

Environment: Informatica PowerCenter 8.5, Oracle 10g, Sybase, SQL, SQL*Plus, SQL Navigator, Teradata, SQL Assistant 12.0, AIX 5.0, UNIX

Confidential, Chesterfield, MO

Senior Database Analyst

Responsibilities:

  • Worked closely with business users for requirements gathering and analysis.
  • Involved in creating High Level Design document and Detail Design document.
  • Developed logical and physical data models that capture data elements.
  • Involved in the initial design phase including the identification of our Sources, Targets, staging areas, Fact and Dimension Tables.
  • Developed mappings and mapplets using Informatica Designer tools - Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer.
  • Developed complex mappings to load the data from various sources into the Data Warehouse, using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Union, Sorter, Update Strategy, and Joiner.
  • Created Sessions, workflows using Workflow Manager and scheduler to schedule the sessions to run at a specified frequency.
  • Used Workflow Monitor to monitor the workflow status.
  • Involved in tuning the Mappings and Sessions to improve 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.

Environment: Informatica PowerCenter 8.1, Oracle 10g, SQL Developer, SQL, Sybase, Windows XP, Visio 2000, Business objects XIR2

Hire Now