PROFILE:

• Competent, diligent & result oriented professional with 5.5 years of experience in designing, developing, deploying and maintaining ETL applications with Informatica power center.
• Talented & technically - astute, with expertise in Systems Engineering, Requirement Analysis, Design, Development, Testing and Integration of software modules.
• Experienced at Creating Effective Test data and development thorough Unit test cases to ensure successful execution of the data.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Extensive experience in supporting production jobs, data enhancements and code fixes.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly growing target mappings, Type1/2/3 dimension mappings
• Involved in ETL testing and performed portfolio SIT and prepared test reports.
• As a part of ETL Job automation, worked on job scheduling tools like Control-M and AUTOMIC
• Well versed with methodologies such as Agile, SCRUM and waterfall.
• Involved in preparation of Requirement Traceability Matrix, Defect Report, and Weekly Status Reports, Checklists, Job Aids, Test Readiness Review Documents.
• Extensive knowledge in design and review of various documents including the Software Requirement Specifications (SRS), Business Requirements Document (BRD), Use Case specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM).
• Good Analytical and Communication Skills and ability to work independently with minimal supervision and perform as part of a team. Ability to work under competing deadlines.

SKILLS:

Requirements Management: Microsoft Office

RDBMS: Oracle 11 C, MS-SQL Server, Teradata

Application Development: Informatica Power Center, Talend

Operating System: Windows

ETL: Informatica Power Center 9.x, 10.1

RDBMS: Oracle 11g

Languages: SQL

Data Modelling Tool: Smart Draw

Scheduling Tool: Control-M, AUTOMIC

Versioning Tools: SVN

Database Tools: TOAD, Netezza, Oracle SQL Developer

Testing Tools: HP Quality Centre, Informatica DVO

Process: Waterfall, Agile, SCRUM

Agile Tool: Rally - CA Agile central

PROFESSIONAL EXPERIENCE:

Confidential

ETL - Data Specialist

Primary Skill: Informatica 9.X &10.1, UNIX, AUTOMIC, SQL, Agile

Responsibilities:

• Worked with Business Analyst in requirements gathering, business analysis and project coordination.
• Analyzed the source data coming from different sources like, DB2, Flat files.
• Worked with business users and developers to develop the model and documentation for the new projects like marketing and ODS building.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression, SQL, Stored procedure, and Update strategy transformations.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters per the requirements and usage of workflow variables for triggering emails
• Implemented complex ETL logic using SQL overrides in the source Qualifier.
• Performed Unit tests development work and validates results with Business Analyst.
• Developed Unix Scripts for updating the control table parameters based on the environments.
• Used DB2 loader to load data from flat files to DB2 target database and created exception tables to populate the rejected records.
• Created various data marts for analyzing different business units.
• Responsible for providing written status reports to management regarding project status, task, and issues/risks.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.

Environment: Informatica Power Center 9.6.1, TOAD 12.8, IBM framework, PL/SQL, SQL, Unix Shell Scripting, Windows XP.

Confidential

Responsibilities:

• Responsible for providing estimates for development, Unit testing, SIT for any new requirement.
• Responsible for creating tech user stories in rally for each sprint.
• Responsible for Creating ETLs and Unix scripts to load data from source till OFSAA.
• Responsible to hand over the code to for SIT/UAT team and proving them walk through of the requirement.
• Coordinating with the parallel development teams for code sync up/migrations to avoid any conflict due to same code base.
• Responsible for doing data quality checks within the code and load errors into the respective error files, tables.
• Implementing balance & control in each layer from landing, staging & Edward.
• Also involved in automating Test data management for different modules which included test file creations, preparation of input sheets used for end to end of modules.
• Automating validation of reports by creating ETLs to extract data from DB & compare with reports.
• Propose effective Ideas to the team to automate various manual testing processes.
• Preparing root cause analysis documents in case of major issues.
• Direct interaction with the client regarding any deliverable, issues, knowledge transfer.
• Analyzing requirement document and resolving open items on discussion with project team and client

Environment: Informatica Power Centre - 9.1/9.6, Oracle SQL, UNIX, AUTOMIC scheduler tool, Control-M, HP Quality Centre, Informatica DVO, CA-Rally, Subversion, WinSCP, Putty, Micro-strategy and MS Office applications.