SUMMARY

• Databases: Seven Plus 7 years experience in dealing with various Data sources like Oracle 11g/10g/9i, SQL Server 2008/2000, Teradata 14/13/V2R6, DB2.
• Data Warehousing: 7 years of Experience in Extraction, Transformation, and Loading ETL using Informatica Power Center 9.1/8.6/7.1.4/6.2 and Informatica PowerExchange 9.0.1/8.6.
• SDLC: 7.5 years exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Data Modeling: Extensive experience in Analyzing the Dimensional Data modeling, Star Schema/Snowflake modeling, FACT Dimensions tables, Physical logical data model using Erwin 4.5/3.1.
• Business Intelligence: Extensive experience in Business Intelligence tools like Business Objects XI and Cognos 7.1.
• Unix: Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms.
• Coordination:Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per the business requirement. Experience working with Onside-Offshore model while co-ordination with peer developers and resolve issues.
• Others:Excellent problem solving, analytical, written and communication skills with ability to work both in team as well as an individual.

COMPUTER SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer/Support Analyst

Responsibilities:

• Co-Ordinated with various team to gather requirement and created technical design doc.
• Worked on data modeling, created HLD, LLD and Unit test case.
• Worked on complex mapping design, coding and testing.
• Worked on Harvest SCM for version control, configuration and migration code.
• Created PowerExchange registration for real-time workflows and data map to read file from mainframe system.
• Created restart token, hanging workflow identification job and auto deadlock restart jobs.
• Worked on Teradata utilities like BTEQ, MLOAD, FLOAD and TPUMP.
• Created and configured real-time mappings, sessions and workflows.
• Worked on Informatica and Sql tuning and customization.
• Provided 24X7 on call support which included monitoring morning and nightly jobs and emergency production fixes.
• Coordinated the Change Management process which involved driving the QA and production deployments.
• Involved in Information administration including creating new users and groups, backing up the repository and domain as well as handling various upgrades.
• Involved in writing and modifying UNIX shell scripts.
• Worked with data quality team to fix the production data issues and also provide solutions to the business users.
• Involved in providing the solutions for production support job failures at Tier-2 level.
• Coordinated with offshore team to support the existing ODS system jobs.
• Coordinated with business users and across the development teams in implementing new business requests.
• Used Toad for data quality verification and unit testing the data.
• Used Teradata, SQL assistant for running the SQL Queries to check the data loaded to the Target Tables.

Environment: Informatica Power Center 9.1, Informatica PowerExchange 9.0.1, Oracle 11g, Teradata 14/13, DB2 mainframe, UNIX Sun-Solaris , UNIX AIX 6.2 , Harvest SCM, SQL Loader, Autosys, Visio, Synsort, TOAD for Oracle, SQL Developer, Windows XP.

Confidential

Sr. ETL Developer

Responsibilities:

• Interacted with business analysts to gather the business requirements by attending regular meetings with the business community.
• Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.
• Developed naming convention document for various component of Informatica.
• Developed ETL code by the business logic defined in the Functional Design Document.
• Analyzed the systems, met with end users and business units in order to define the requirements.
• Conducted business requirements and source system analysis to arrive at optimal ETL designs.
• Develops new ETL applications from simple to moderately complex scope, works with basic applications systems design specifications and utilizes Company standards, procedures, and techniques.
• Partnering with project managers and development resources to assist with design changes and design decisions.
• Used SQL developer to run the queries to verify the data with the existing GUI functionality.
• Involved in creation of test plan and test cases for testing the enhanced functionality of MBOX.
• Involved in documentation to describe program development, logic, coding, testing, and any changes and corrections.
• Worked with creation of reports for decision support.
• Involved in analysis of the data in the development and test environment.
• Work with analog team to test the existing application.
• Involved in logging defects in JIRA and monitor the progress until it goes to UAT environment.
• Worked on prod support of real-time projects.
• Used Informatica user defined functions to reduce the code dependency.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I II in different mappings as per the requirements.
• Performing ETL database code migrations across environments.

Environment:Informatica Power Center 9.1/8.6, Informatica PowerExchange 9.0.1/8.6, Oracle 11g, Teradata 12, Sql Server 2000, Linux, ESP, Visio, Synsort, SQL Developer, Windows XP, JIRA.

Confidential

Consultant Program Analyst/ETL Developer Responsibilities:

• Provided production support by running the jobs and fixing the bugs.
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Aided in migrating the code across various environments.
• Worked on test cases and test plans.
• Documented the process for further maintenance and production support.
• Involved in the documentation/Design of Technical Design Document of various interfaces like Sales organization, Field AOP, and Field Forecast.
• Used Teradata, SQL assistant for running the SQL Queries to check the data loaded to the Target Tables.
• Designed and developed mappings, mapplets and sessions from source to target database using Informatica Power Center.
• Used simple to moderately complex debugging techniques to test ETL applications.
• Developed Test Cases for testing the ETL mappings.
• Conducted code reviews and lead design reviews to assure compliance.
• Involved in migration of ETL/Bteq code from Development environment to QA environment and finally to Production environment.
• Followed Informatica development standards and enforce best practices.
• Performed QA work to verify the results provided from other teams.
• Worked with various file formats like fixed length and delimited.
• Involved in creation of BTEQ Script for validating the data quality like referential integrity, not null check.
• Maintained the proper communication between other teams.
• Utilizing the existing UNIX shell scripts to run the informatica workflow through process control.
• Scheduled sessions and batch process based on demand, run on time, run only once using Informatica Workflow Manager.
• Identified BI reporting problems, and suggests practical resolutions.
• Participates in on-call support for ODS and the data warehouse.
• Involved in documentation to describe program development, logic, coding, testing, and any changes and corrections.

Environment: Informatica Power Center 8.1, Teradata V2 R6, SQL, Windows XP, SQL Assistant, UNIX Shell Script.

Confidential

Informatica Developer

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.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Prepared estimates and tracked each and every task and strictly adhered to the estimated deadlines.
• Extensive knowledge in promoting packages code across development, test, preproduction and production environment using tools like Computer Associate Harvest package.
• Co-ordinate with Off-Shore team in INDIA.

Environment: Oracle 10g, SQL Developer, SQL , Informatica Power Center 8.1 ,Sybase, Windows XP, Visio 2000, Business objects XIR2, Linux, Sql Server 2000.

Confidential

ETL Developer/Data Analyst

Responsibilities:

• Involved in requirements gathering and data gathering to support developers in handling the design specification.
• Extracted data from various source systems like Oracle, Sql Server and flat files as per the requirements.
• Created ETL design docs, test case and migration documents.
• Developed complex mappings, unit test case and reviewed teammates codes.
• Updated and remediate existing Business Intelligence scripts and Teradata applications to reflect changing business data requirements.
• Extensive experience in writing and executing scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
• Involved in loading of data into Teradata from legacy systems and flat files using complex
• scripts.
• Leads the planning, analysis, design, implementation, maintenance, and control of the organization's server-class databases.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
• Involved in understanding Business and data needs and analyze multiple data sources and document data mapping to meet those needs.
• The mappings involved extensive use of transformations like Aggregate, Filter, Join, Expression, Lookup, Update Strategy, Expressions, Sequence Generator Transformations. Used debugger to test and fix mapping.
• Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.

Environment:Informatica 8.1, Oracle 10g, Teradata V2R6, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, FTP, Windows XP, Cognos, Visual Basic 6.

Confidential

Database Developer/ETL Developer

Responsibilities:

• As a team member involved in collecting all the requirements for building the database.
• Involved in Creation and designed required tables, indexes and constraints for all production 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.
• Used SQL, PL/SQL for database related functionality.
• Performed complex defect fixes in various environments like UAT, SIT etc to ensure the proper delivery of the developed jobs into the production environment.
• Responsible to write complex SQL queries and PL/SQL procedures to perform database operations according to business requirements.
• Worked with the testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project, and also fixed the defects before moving the jobs into production.
• Document all ETL related work per company's methodology.
• Attended production implementation calls and co-ordinate with the build engineers during migration of the code and was highly acknowledged.

Environment:Informatica Power Center 7.1, Oracle 10g, SQL Server 7.0 , SQL, Sybase, PL/SQL, Erwin3.5, UNIX, Windows XP, C.

Confidential

Informatica Developer/Unix Admin

Responsibilities:

• Worked with different Sources such as Oracle, SQL Server and Flat files
• The data that was obtained from various sources were fed into the staging area in Teradata. Enterprise wide templates were created for handling SCD, Error handling etc. Used Service Request to log in and track the tickets/ service requests. Worked in resolving production issues providing apt solutions with tight deadlines and SLA's. Involved in loading of data into Teradata from legacy systems and flat files using complex MLOAD scripts and Fast Load. Extracted data from Oracle database transformed and loaded into Teradata database according to the specifications. Involved writing BTEQ scripts for validation testing of the sessions, data integrity between source and target databases and for report generation Involved in writing Teradata SQL bulk programs and in Performance tuning activities for Teradata SQL statements using Teradata EXPLAIN Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata database. Involved in analysis, development, testing, implementation and deployment. Created debugging sessions for error identification by creating break points and monitoring the debug monitor. Developed technical design documents LLD based on the functional requirements Used scheduling tools like DRIFT2K. Involved in troubleshoot, debug, fix and test production support issues Implemented AGILE methodology for our formal delivery.

Environment:Informatica Powercenter 6.2, Oracle 9i, Mainframes, Linux, BO XI.