We provide IT Staff Augmentation Services!

Sr. Etl Informatica Developer Resume Profile

Atlanta, GA

Professional Summary:

  • More than 8 Years of IT experience.
  • Worked in complete Software Development Life Cycle SDLC , starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and till maintenance.
  • Worked on Oracle Database supporting OLTP and Data Warehouses.
  • Also worked on the ETL Tools like Informatica, Ab-Initio and Reporting tools like Cognos, OBIEE.
  • Strong experience with Informatica tools Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager, Workflow Manager and Workflow Monitor, and DAC as Scheduler tool.
  • Developed effectively different type of SCD's based on the specifications.
  • Sound experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data for a company merger projects.
  • Successfully co-coordinated for the project activities in off-shore/onsite model with a team of 12 members.
  • Experience in developing Test Strategies, Test Plans, Test Cases, and Test Scripts and provided 24x7 production support.
  • Experience in T-SQL Programming skills. Experience in query optimization performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Experience in interacting with onsite clients while being responsible for deliverables.
  • Ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries.
  • Quick to learn.
  • Good team player, strong interpersonal and communication skills combined with self-motivation initiative and positive attitude.
  • Looking ahead for great personal and professional career in a fair working environment with opportunities to grow.
  • Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.

Technical Skills:

Operating Systems: UNIX, Windows XP/2003/2007

Languages: C, C , Java, SQL, PL/SQL

Databases: Oracle, MS Access, DB2

Web Related: HTML

ETL Tools: Informatica, Ab Initio, OLAP

Schedulers: DAC Data Warehouse Administration Console , CA7 in Mainframes, Crontab in UNIX

Reporting Tools: Cognos, OBIEE

Utilities: TOAD, SQL Developer

Professional Experience:

Confidential

Role: Sr. ETL Informatica Developer

Responsibilities:

  • Performed role of ETL Developer which includes requirement analysis, design, development, testing, documentation and production deployment.
  • Worked on Informatica Power Center to develop mappings, sessions and workflows.
  • Built Staging layer with error checks, WH and Marts to enable data exchange with external systems.
  • Involved working on Oracle database, designing and creating tables, relations, constraints, indexes, PL-SQL functions and procedures.
  • Also developed UNIX Shell Scripts to automate the ETL processes.
  • Extensively involved in writing SQL queries sub queries and join conditions for building and testing ETL processes.
  • Designed mappings for Slowly Changing Dimensions Type 1 Type 2 , used Lookup connected and unconnected , Update strategy and filter transformations for loading historical data.
  • The weekly historical load of data from different geographic locations like NA, LA, WE, CE, AAI, GC, NEA. The system developed used to receive SAP-BW file from Gillete which was then converted into P G standards and loaded into the ADW system.
  • The process was designed to run on a weekly basis for all the 7 different regions. The weekly run timings for different regions were different.
  • Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings, fixing re-running and developing error-handling methods.
  • Performed Admin tasks like recycling the services Repository and Integration services , purging log files, creating users, groups, roles, folders and assigning privileges permissions.
  • Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
  • OLTP On-line Transaction Processing and OLAP Online Analytical Programming system will provide source data to data ware house which helps OLAP in data analysis.
  • Created Function specification, High level design document ETL design architecture and Low level design document and Unit Test Case, deployment and operational document.
  • Role also involved leading the onshore and offshore team members, assigning and reviewing their work.

Environment: Informatica Power Center 8.5/8.6, Cognos, SAP, Erwin, MQ Series, Altiris, Oracle 10g, DB2 8.1.6/8.2.0, UNIX, Windows NT 4.0, PL/SQL, T-SQL, SQL Loader, SSIS, Business Objects 6.0, TOAD Quest Software.

Confidential

Role: Sr. ETL Informatica Developer

Responsibilities:

  • Designed the Mapping Spreadsheet and Functional Design Documents for the Source to Stage, Stage to Data Prep and Data Prep to Target mappings.
  • Created the Physical and Logical Data Models using ER Studio Data Architect.
  • Elaboration of Legacy Mainframe Files.
  • Build the mappings for Profile tables from Data Prep Tables.
  • Pre- Populated all the data required for the Fixed/Profiles tables using mappings and Stored Procedures.
  • Created the Data Maps for the Mainframe Files Copybooks.
  • For the conversion/historical data, the different source systems used are Legacy Mainframe files, DB2, Oracle and SQL Server ODS Systems , XML Files and BP ODS CP ODS Systems are sourced for Daily changes Change Data Capture
  • Conducted user interviews with all the Business Partners and gather the requirements.
  • Build and Unit tested all the mappings for Source to Stage, Stage to Data Prep Data Prep to Target Tables.
  • Provided reports using OLAP capabilities of Cognos Reports for the purpose of data analysis
  • Followed the Agile methodology and delivered the Data Assest per each Subject Areas.
  • Executed different scenarios in Unit Testing, Integration Testing, Data Validation, System Testing and User acceptance testing.
  • Produced the reports using SSAS for the Business users.

Environment: INFORMATICA POWER CENTER 9.5.1, INFORMATICA POWER EXHANGE, 9.5.1, Unix , windows Shell Scripting, SQL Server, Pl/SQL Stored Procedure , Oracle 11g, DB2, Teradata, Ultra Edit, Quest Putty, TFS , Clear Quest , SQL Server Management Studio , SSIS, SQL Developer , ER Studio Data Architect and XML Files.

Confidential

Role: ETL Informatica Developer

Responsibilities:

  • Actively involving in the 24 7 support and doing the enhancements wherever required.
  • Analyzing and fixing the code in production instantly after doing quick testing in production-like environment whenever there is a job failure due to the code issue.
  • Tuning the Informatica workflows for optimal performance.
  • Creating scripts in Unix for auditing and scheduling of Informatica batches
  • Providing the permanent fix whenever the jobs get failed due to repeated issues.
  • Preparing the documentation for easy maintenance of project.
  • Update Business whenever there is any delay in the batches for any reason and plan accordingly so that there should not be much impact to Business.
  • Actively participating in the DR Disaster Events that take place over the weekends in every quarter.
  • Working over the incidents/tickets that are created by different business users by prioritizing them based on issue criticality.
  • Providing necessary support for OBIEE queries whenever required.
  • Provides spontaneous response to the queries posted by business users and supporting teams.
  • Track the status of work from time to time and provide timely updates to team lead.
  • Assign the team members accordingly to complete the work based on their competent.
  • Working along with the team as a part of the regular activities in day-to-day work besides his other responsibilities.
  • Automated the jobs by considering their internal dependencies and based on upstreams.
  • Closely working with Business users during the month-end batches and provides timely updates in terms of status of the batches as they get executed continuously for 2 days as these are very critical to the Business for reporting purpose.
  • Creating the OBIEE reports based on adhoc requirements from Business.
  • Handling escalations in the best way whenever there are any.
  • Scheduling the calls with Business users to understand the issues clearly and solve the issue accordingly.
  • Encouraging the team to participate in multiple events that are conducted by Organization.

Environment: Informatica Power Center 8.6.1, Oracle 11, UNIX, Tivoli, OBIEE 10, TOAD andMainframes.

Confidential

Role: Informatica Developer

Responsibilities:

  • Participated in discussion with senior management team for the better understanding of business requirements.
  • Hands on experience in handling large volumes of data in production environments.
  • Created Sessions, Reusable Worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
  • Prepare the road-map for the completion of tasks and plan to share the work among the team as per each individual capability.
  • The EP's were scheduled at DAC level as per client specifications after creating the tasks, assembling 'subject areas' and building the 'Execution plans'.
  • Participated in the DAC implementation.
  • Helping the team in resolving technical/non-technical issues.
  • SIL- Source Independent loading, where the transformed data will be loaded into the final target tables.
  • SDE - Source dependent Extraction, where the data gets extracted from different source systems to staging tables. This is the staging area.
  • Designed the project in such a way that there are 2 phases, SDE and SIL, as per the BI standards at Informatica level.
  • Involved in Analysis phase of business requirement and design of the Informatica mappings using low level design documents.
  • Involved in Performance tuning by determining bottlenecks in sources, mappings and sessions.
  • Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
  • Troubleshooting the loading failure cases, including database problems
  • Prepared Documents like Technical Design Doc, Production Support Doc, Deployment Doc
  • Documented Mappings, Transformations and Informatica sessions.
  • Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
  • Used TOAD to run SQL queries and validate the data in warehouse and mart.
  • Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.

Environment: Informatica Power Center 8.6.1, OBIEE 10, DAC, UNIX, Oracle 11, SSIS, SQL, PL/SQl and TOAD.

Confidential

Role: Informatica Developer

Responsibilities:

  • Designed and developed Informatica mappings for data loads and data cleansing.
  • Developed mappings with XML as target and formatting the target data according to the requirement.
  • Developed code to load the data from Flat File to stage and stage to DWH.
  • Migrating objects between different Environments using XML Export/Import using Repository Manager .
  • Monitoring the Jobs, observing the performance of the individual transformations and tuning the code Performance Tuning
  • Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
  • Worked mostly on Lookup, Aggregator, and Expression Transformations to implement complex logics while coding a Mapping.
  • Worked on Informatica tools like Designer, Workflow Manager, and Workflow Monitor.
  • Arranged weekly meetings with the offshore team and discuss both the technical and non-technical issues along with the status of work from time to time.
  • Worked with Business analysts to understand business/system requirements in order to transform business requirements into effective technology solutions by creating Technical Specifications Source to Target Documents for the ETL from the Functional Specifications.
  • Created mappings to incorporate Incremental loads.
  • Developed reusable Mapplets to include the Audit rules.
  • Working with Power Center Versioning Check-in, Check-out , Querying to retrieve specific objects, maintaining the history of objects.
  • Designed the Workflow for the ODS load following the load Dependencies.
  • Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
  • Solely responsible for the daily loads and handling the reject data.
  • Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
  • Creating stored procedures and sequences to insert key into the database table.
  • Involved in writing PERL scripts for file transfers, file renaming and few other database scripts to be executed from UNIX.
  • Extensively Used Perl Scripting to schedule the Informatica Jobs.
  • Maintained/Fixed bugs in existing PERL scripts.
  • Guided the testing team and the development team and monitored the Implementation.
  • Provided support for the Nightly jobs.

Environment: Informatica Power Center 8.6, Erwin 4.5, Oracle 10g, PL/SQL Developer, XML, Windows XP, PL/SQL, PERL, TOAD

Confidential

Role: ETL Informatica Developer, PL/SQL Developer

Responsibilities:

  • Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
  • Tracked the status of work from time to time and provided timely updates to team lead.
  • Gathered requirements from Client through calls and emails.
  • Development and testing of mappings at Informatica level.
  • Created PL/SQL Packages in Oracle for data validations like Database Validations i.e. primary, foreign key and check constraints as per the functional and technical documents.
  • Provided test results to client and get sign-off for the same to deploy code in live environment.
  • Migrated the code from UAT to production environments.
  • Fix the issues as per the results of validations from PL/SQL packages in production.
  • Provided spontaneous response to the queries posted by business users and supporting teams.
  • Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.

Environment: Oracle 9i, SQL, Informatica, TOAD, SQL Developer, PL/SQL, UNIX, Shell Scripts.

Confidential

Role: ETL Developer

Responsibilities:

  • Analyzed the existing business model.
  • Interacted with business users on weekly basis in finalizing high-level business requirements.
  • Prepared detail-level design documents based on the discussions to get sign-off from business.
  • Analyzed the impact and provided estimations in PD's to Client whenever there was a change in client requirements.
  • Created Informatica jobs to extract data from different external sources and populate into data warehouse tables/flat files by transforming the data as per business rules.
  • Involved in Unit testing and Integration testing of Informatica workflows.
  • Responsible for tuning the Performance of Informatica ETL mappings.
  • Reviewing and testing of mappings, sessions, workflows.
  • Analyzing the impact and providing the Estimations to Client in PD's whenever there is a change in the requirement.
  • Provided the warranty support by interacting with production support teams.

Environment: Oracle 9i, SQL, Informatica, TOAD, SQL Developer, PL/SQL, UNIX, Shell Scripts.

Hire Now