PROFESSIONAL SUMMARY:

• 14 plus years of IT experience working in Data Warehousing, Database and UNIX, Hadoop,Hive extensive understanding of software development, testing and debugging and support.
• Experience in ETL processing using Informatica Power Center 8.x/9.x,10. x.
• Experience using RDBMS oracle, SQL server, Teradata, DB2, Hive, HDFS
• Experience in development and providing support for major as well as minor releases involving Informatica products.
• Experience in all teh phases ofData warehouse life cycleinvolving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in working withbusiness analysts to identify study and understandrequirements and translated them into ETL code in Requirement Analysis phase.
• Extensive Data Warehouse experience using Informatica Power Center / Power Mart (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Designer) as ETL tool on DB2 and Oracle Database.
• Experience in creatingHigh Level Design and Detailed Designin teh Design phase.
• Extensive functional and technical exposure. Experience working on high - visibility projects
• Assign work and provide technical oversight to onshore and offshore developers
• Solid experience in analyzing and fixing Production issues in teh current Informatica Applications.
• Experience which Includes area like Data Warehouse/ETL/Informatica Developer using ETL Tools, DB2, oracle. Experience with Informatica ETL Tool for Data Extraction, Transformation and Loading.
• Worked on Mappings, Mapplets, Power center Designer, Repository manager, work flow monitor.
• Teradata's SP/View/BTEQ development, ODBC/BTEQ, Fast, Multi load connection ensuring teh Load Date and Load Time are also captured in teh Teradata tables.
• Expertise in utilizing Secured Shell Client tool for interacting with UNIX operating system, Citrix Client and VPN for remote server connectivity.
• Experience in all phases of Data warehouse development from requirements gathering for teh data warehouse to develop teh code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of teh ETL processes using UNIX shell scripting.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Worked in entire life-cycle beginning from Requirements gathering, Data Model Design, ETL Design, Report Design, Testing, and Migration to Production.
• Understand teh business rules completely based on High Level document specifications and implements teh data transformation methodologies.
• Created UNIX shell scripts to run teh Informatica workflows and controlling teh ETL flow.
• Designed and developed Informatica Mappings and Sessions based on requirements andrules to load data from Files and Relational DBs
• Extensive experience in key Utilities concepts - Metering, Billing, Payments collection, Debt Collection etc.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C

Scripting: UNIX shell scripting (ksh)

Databases: Oracle 11g/10g/9i/8i, SQL Developer, SQL Server 2005 / 2008, DB2,Teradata,vertica

ETL Tools: Informatica PowerCenter V 9.6.1/9.1.0/9.0.1/8.6.1, Informatica developer tool (Big data Edition)Other: Autosys, Control - M, SQL*Plus, TOAD for Oracle, Toad for Db2, Tidal,Big data,Hive,Hadoop,Github,Jenkins, Active Batch

Operating Systems: AIX, Windows 95/98/2000/NT/XP, MS DOS

Methodologies: Modeling, Data Warehouse Life Cycles

PROFESSIONAL EXPERIENCE

Confidential

Lead Engineer

Responsibilities:

• Acquire teh data using in - house Turbo data mover tool from Multiple Sources to Core Database and capture teh stats using Audit, balance and control mechanism.
• Integrate teh data from CORE on daily basis by applying business transformation and save data into Conform and Provisioning layers for further analytical reporting.
• Design and develop standard data extract framework which will enable electronic data extracts in 834/837I/837P formats as well as other configured formats.
• Build specialized data objects (SDO) from Member, Provider, claim subject area models to accommodate various downstream and vendor requirements
• Using Informatica Power Center, create mappings and mapplets to transform teh data according to business rules. Data Quality and Address for data cleansing and profiling.
• Preparation of Extraction Transformation and Loading Architectural and Design document.
• Participate in Scrum meetings and coordinate with Business Analysts to review, analyze and understand teh business needs and implement teh same into a functional design and give suggestion on implementation approach for which best suites.
• Participating teh project demo meeting and explaining teh approach following and explaining teh process to teh users
• Build teh Teradata stored procs with required transformations provided by teh business users along with error handling, duplicate data check validations etc.
• Apply Data Quality checks within teh stored procs/ABC scripts like variance difference observed between last two days, if teh variance difference is more than teh defined, trigger an automated email to teh business users for teh confirmation.
• Developing Complex SQL script to load data to ‘OSS Data warehouse’ DataMart tables.
• Creating Teradata Stored Procedures to load data from OSS to other Internal/external Systems.
• Develop teh generic reusable stored procedures, to automate teh load process for teh source files received from teh different operational systems to Teradata database.
• Write source code, prepare test data, tests and debug programs, revise and refine programs to improve performance of teh queries.
• Write ETL code to parse structured and unstructured files on Informatica power center and Informatica developer (Big data edition) and other supporting environments such as UNIX, Teradata and HIVE to achieve teh concept of single source for all enterprise data.
• Develop Informatica mappings and implement optimization techniques like Push down optimization, tuning to achieve maximum efficiency and capture teh same in runbook.
• Creating detail design documents, conduct review sessions to walk through design documents and create technical specification documents.
• Involved in loading various delimited files like comma separated, pipe delimited, tab delimited files into Teradata database.
• Works on teh service improvement plans such as monitoring scripts, automation to improve teh stability of teh applications.
• Migrate Customers, Medicaid information from OSS system to data lake/analytics (Cloudera), mainly teh process to ingest data from teh sources in batch or real time based on teh business need.
• Teradata's SP/View/BTEQ development, ODBC/BTEQ, Fast, Multi load connection ensuring teh Load Date and Load Time are also captured in teh Teradata tables.
• Lead teh technical discussions with teh product owners and subject matter experts to finalize teh source to target mapping as well as achieving other business and functional requirements.
• Responding to all Business Queries and ensure teh performance and availability of teh application in meeting SLA.
• Creation of High-Level Design including sequence diagrams and class diagrams for teh system architecture.
• Responsible in design solutions and proof of concepts (POCS).
• Implementing slowly changing dimensions (SCD) for some of teh Tables as per user requirement.
• Conduct peer code reviews to ensure use of best practices and to verify correct implementation of requirement.
• Provide status report to client and Wipro Management in a weekly basis.

Confidential

Lead Engineer

Responsibilities:

• Identify customer’s business flow and gap analysis, provide recommendations in key strategic areas involving competitor performances.
• Implementing one full copy of loan data structure in ELZ (enterprise landing zone) using ETL tools.
• Involving in analysis of teh Business requirements and understanding of technical specifications.
• Participating in preparation of Extraction Transformation and Loading Architectural and Design document, creating detail design documents, Conduct review sessions to walk through design documents and create technical specification documents.
• Build Informatica workflows and mappings to transform data from SOR to enterprise data such as Anti money laundering (AML) and Know your Customer (KYC) and customer 360.
• Working on ETL tools such as Informatica power center and Informatica developer ( Big data edition ) and other supporting environments such as UNIX,SQL server, Main Frame and HIVE to achieve teh concept of single source for all enterprise data.
• Importing teh data of system of record (SOR) using Informatica power exchange, Database, flat files and process each record type to ELZ RAW layer using Informatica power center, developer tool
• Processing data from ELZ RAW layer to harmonized layer (HMN) by applying enterprise data quality rules.
• Worked on teh HDFS file and hive table creation of data . Teh data for RAW and HM is stored in HDFS layer and hive table on it.
• Storing data in harmonized layer in different folders of distributed file system to facilitate incremental load and further processing incremental data.
• Worked in Big data architectures like HADOOP and HDFS to store enterprise source application data in ELZ.
• Worked on teh framework where data is been pulled from SOR to RAW and HM usingframework process.
• Design, development of mappings, transformations, sessions, workflows and ETL batch jobs using informatica power center and informatica developer tool.
• Documentation of Source to Target matrix, mapping specifications, Mapping inventory, Unit test plans, HDFS file system, Hive table creation.
• Worked on teh service improvement plans such as monitoring scripts, automation to improve teh stability of teh applications.
• Responding to all Business Queries and ensure teh performance and availability of teh application is good.
• Ensure ETL workflows and mapping are delivered on schedule.
• Scheduling teh Informatica jobs through AUTOSYS tool.
• Gather teh requirements from Analyst for teh project. Teh TAD document will be reviewed with analyst.
• Maintain standard documentation and templates related to development.
• Coordinate with test lead for defect fixes and code turnover.
• Unit testing, peer reviews and System testing support, defect fixing, data loading support and User acceptance testing support.
• Deploying teh current application into teh Sandbox, DEV, QAT, IT and PROD environment for each release and troubleshooting if any environmental issues on teh spot.
• Builds and leads project plans for one or more teams including resource requirements, deliverables and timelines. Assigns specific tasks to team members.
• Translate highly complex concepts in that way that can be understood by a variety of audiences.
• Involving in creation of High Level Design including sequence diagrams and class diagrams to understand teh existing architecture.
• Handling work scheduling to Offshore team and monitor till final sign off. Daily follow up on execution status and providing clarification of ambiguities and also conducting training sessions for team on domain related topics and noledge on different tools.
• Specialized in Banking and Financial domain functionalities (Theoretical and practical noledge).
• Provides technical leadership on implementation projects and performs detailed technical tasks at client sites.

Confidential

Lead Engineer

Responsibilities:

• Gather requirements, Analyze, Design, Code, Oracle, Source systems, Main frame (DB2) systems, flat files, Unix Shell Scripting. Responsible for Functional design, technical design, coding, testing, debugging, and documentation.
• Design, development of mappings, transformations, sessions, workflows and ETL batch jobs.
• Documentation of Source to Target matrix, mapping specifications, Mapping inventory, Unit test plans.
• Unit test processes to ensure proper functioning, and collaborate with other team members.
• Adhere to Informatica SDLC, policies, procedures and industry best practices with respect to system design, architecture, naming and coding standards and system development lifecycle steps.
• Worked closely with business application teams, business analysts, to ensure teh ETL solution meets business requirements. Performance improvement changes to teh Informatica code queries.
• Developed new mappings, workflows with new business requirements and Report teh project status to teh management.
• Developed project plans with team members to ensure Informatica solutions are executed and delivered as per teh plans with good quality.
• Mentor teh team members in teh design and development of mappings & workflows with onsite/offshore execution model.
• Daily, Weekly & Monthly Status calls with offshore teams and key stake holders in teh project.
• Interacting with business users and customers to understand and resolve teh data related issues in application.
• Responsible for review of teh ETL module till production migration and stabilization.
• Prepared KT documents and given KT to team members on new modules development.
• Worked on Production deployments for main code and further fixes.
• Responsible for unit, integration and regression testing for teh new ETL development.

Confidential

Lead Engineer

Responsibilities:

• Analyzing teh existing reports and architecture.
• Analyzing existing coding (Stored Procedures) and OLTP database to transform into ETL coding and creation of OLAP database.
• Preparing teh HLD and LLD, informatica-mapping documents. Preparing test cases coordinating with onshore team.
• Build informatica end-to-end mappings.
• Interacted with business analysts and translate business requirements into technical specifications.
• Designed and developed end-to-end ETL processfrom various source systems toStaging area, from staging to Data Marts.
• Extensively worked on Informatica to extract data fromFlat files, Excel files, and MS Access databaseto load teh data into teh target database.
• Implemented teh Incremental loading of Dimension and Fact tables.
• CreatedStored Proceduresfor data transformation purpose.
• CreatedTasks, Workflows, Sessionsto move teh data at specific intervals on demand using Workflow Manager.
• Prepared teh test cases and got teh sign-off from Business.
• Created deployment groups and migrated teh code from Dev to QA environments
• Performed teh unit testing and integration testing as per test cases.
• Involved Business wherever needed and got necessary approvals by contacting various teams (like Business users, Informatica Admins, Change Management)
• Deployed teh code to Production following teh process from end to end.
• Update teh Business and Managers about teh timely status of work completion and projected timelines.

Confidential

Lead Engineer

Responsibilities:

• Gather requirements, Analyze, Design, Code, Test highly efficient and highly scalable integration solutions using Informatica, Oracle, SQL, Source systems flat files, Unix Shell Scripting. Responsible for Functional design, technical design, coding, testing, debugging, and documentation.
• Design, development of mappings, transformations, sessions, workflows and ETL batch jobs, shell scripts to load data into Source/s to Stage, Data warehousing &DataMart using Informatica, Tidal scheduler
• Documentation of Source to Target matrix, mapping specifications, Mapping inventory, Unit test plans
• Unit test processes to ensure proper functioning, and collaborate with other team members during system and integration testing phases to ensure proper functioning as part of teh larger system.
• Adhere to Informatica SDLC, policies, procedures and industry best practices with respect to system design, architecture, naming and coding standards and system development lifecycle steps.
• Worked closely with business application teams, business analysts, data architects, database administrators and BIS reporting teams to ensure teh ETL solution meets business requirements. Performance improvement changes to teh existing code of Informatica.
• Scheduling teh Informatica workflows using Tidal scheduling tool & trouble shooting teh Informatica workflows.
• Enhancing teh existing mappings, workflows with new business requirements and Report teh project status to teh management.
• Developed project plans with team members to ensure Informatica solutions are executed and delivered as per teh plans with good quality. Mentor teh team members in teh design and development of mappings & workflows with onsite/offshore execution model.

Confidential

Lead Engineer

Responsibilities:

• Co-ordination between onsite and offshore team. Liaising with onshore Business Team.
• Analysis and study of teh system in order to provide teh estimate and Design to client for development projects. Communicate with teh client for solution design details.
• Prepare teh Design (Macro - High level and Micro - Low level) for enhancement and development project.
• Carry out Build process (programming) and Unit test plan preparation and execution.
• Reviewing teh design and responsible for sign off to enhancement request
• System Test and User Acceptance Test support to client.
• Scheduling teh release activities (element promotion in different regions like Development, System testing, Acceptance and Production).
• Design, development of mappings, transformations, sessions, workflows and ETL batch jobs, shell scripts to load data into using Informatica, Unix Shell scripts, Tidal scheduler.
• Responsible for allocation of team resources based on their competencies, which ensured successful deliveries.
• Fixing teh production issue.
• Prepare and update SMTD (System Maintenance Technical Document)
• Planning and conducting technical/functional training for new team member.
• Ensuring compliance to quality standards, and delivery timelines
• Heavy Involvement in providing responses for RFI and RFP.
• Developed a Reject report for finding teh reject records along with teh reason for rejecting those in ETL
• Created shell scripts for automation of teh several manual activities like version verification and reporting teh job completion
• Interacted with Business owners in status meeting and understand their requirements for enhancing and fixing teh current issues in teh existing system.
• Preparation of Data Dictionary based on SME (Subject Matter Expects) discussions.
• Preparation of data separation test cases and Capture test Results in Quality Center by logging teh defects.
• Handled teh special characters in teh source data and there by adjusting teh code page settings in teh informatica for proper output data.
• Designed Test Cases and Test Planes
• Involved in Tracking of Issues and maintaining standards and best practices

Confidential

Lead Engineer

Responsibilities:

• Co-ordination between onsite and offshore team. Liaising with onshore Business Team.
• Analysis and study of teh system in order to provide teh estimate and Design to client for development projects. Communicate with teh client for solution design details.
• Prepare teh Design (Macro - High level and Micro – Low level) for enhancement and development project.
• Carry out Build process (programming) and Unit test plan preparation and execution.
• Reviewing teh design and responsible for sign off to enhancement request.
• System Test and User Acceptance Test support to client.
• Scheduling teh release activities (element promotion in different regions like Development, System testing, Acceptance and Production).
• Responsible for allocation of team resources based on their competencies, which ensured successful deliveries.
• Fixing teh production issue.
• Prepare and update SMTD (System Maintenance Technical Document)
• Build informatica end to end mappings.
• Planning and conducting technical/functional training for new team member.
• Ensuring compliance to quality standards, and delivery timelines.
• Heavy Involvement in providing responses for RFI and RFP.

Confidential

Lead Engineer

Responsibilities:

• Analysis, design, and coding of teh project.
• Test case preparation and testing
• Migration of code in different environments.
• Coordination with interface teams.
• Proposals for solutions based on Business requirements
• Impact Analysis and Estimations.
• Fixing teh production issue.
• Build informatica end to end mappings, review teh developed codes
• Prepare and update SMTD (System Maintenance Technical Document)
• Planning and conducting technical/functional training for new team member.
• Ensuring compliance to quality standards, and delivery timelines
• Heavy Involvement in providing responses for RFI and RFP.
• Created teh detail design documents after analyzing teh business and teh databases.
• Interaction with teh business users for gathering teh requirements.
• Created Informatica Workflows as per teh business rules to load data into oltp databases.
• Responsible for Tuning teh Performance of teh ETL mappings.
• Reviewing and testing of mappings, sessions, workflows.
• Created scripts in Unix for scheduling teh Informatica jobs
• Shared teh test results to Business and got teh sign-off for migrating teh code to Production.
• Created scripts in Unix for scheduling teh Informatica jobs
• To add on, Unix scripts were also created for validating teh data between sources and corresponding targets.

Confidential

Lead Engineer

Responsibilities:

• Analysis, design, and coding of teh project.
• Test case preparation and testing
• Migration of code in different environments.
• Coordination with interface teams.
• Build informatica end-to-end mappings.
• Preparation of High Level Design Documents, Low Level design Documents
• Build and Unit testing.
• Preparing Unit/Integration Test Plans and Unit/Integration Test Results
• Development and review of teh Low Level Design, Code, Unit / Integration Test Plans, Unit / Integration Test Results
• Developed a Reject report for finding teh reject records along with teh reason for rejecting those in ETL
• Created shell scripts and Perl scripts for automation of teh several manual activities like version verification and reporting teh job completion
• Interacted with Business owners in status meeting and understand their requirements for enhancing and fixing teh current issues in teh existing system.
• Preparation of Data Dictionary based on SME (Subject Matter Expects) discussions.
• Preparation of data separation test cases and Capture test Results in Quality Center by logging teh defects.
• Handled teh special characters in teh source data and there by adjusting teh code page settings in teh informatica for proper output data.
• Designed Test Cases and Test Planes
• Involved in Tracking of Issues and maintaining standards and best practices.
• Proposals for solutions based on Business requirements
• Preparation of Mid-Level Platform Design
• Impact Analysis and Estimations
• High Level Designing
• Build informatica end to end mappings.
• Development and review of teh Low Level Design, Code, Unit / Integration Test Plans, Unit / Integration Test Results
• Ownership of delivery of specific modules
• Induction / Training sessions for teh team and mentoring teh new joinees.
• Preparation of Dress rehearsal/Proving rehearsal/Implementation plans and supporting phase wise implementation
• Developed complex transformations like XML parser and xml generator.
• Supported application and fixed teh defects raised by teh users with in sla time.
• Preparation of Design Documents and Unit Test Cases and cost estimation documents by analyzing teh complexity of teh requirements
• Leads a team of three members for developing and delivering teh tested code that meets teh requirement.
• Developed re-usable transformations, mappings and mapplets confirming to teh business rules. Used Debugger to test teh mappings and fix teh bugs.
• Analysis, design and coding of teh project.
• Test case preparation and testing
• Build informatica end to end mappings.
• Migration of code in different environments.
• Coordination with interface teams.
• Designed ETL processes using Informatica to load data from Oracle, Flat Files, Excel files to Teradata database
• Developed mapping and netezza scripts for teh different process in teh bank domain like adjustment process, HPC and CSAR with teh data control mechanism.
• Developed Scheduling through autosys.
• Implemented projects end to end by use of all sort of transformations like sql,java transformations in informatica 8.6.
• Implemented netezza stored procedures, data control checks and views for reporting requirements.

Confidential

ETL Developer

Responsibilities:

• Analysis, design and coding of teh project.
• Build informatica mappings.
• Handled all teh phases of teh project independently.
• Test case preparation and testing
• Prepared High Level design documents for application.
• Developed a Reject report for finding teh reject records along with teh reason for rejecting those in ETL
• Created shell scripts and Perl scripts for automation of teh several manual activities like version verification and reporting teh job completion
• Interacted with Business owners in status meeting and understand their requirements for enhancing and fixing teh current issues in teh existing system.
• Preparation of Data Dictionary based on SME (Subject Matter Expects) discussions.
• Preparation of data separation test cases and Capture test Results in Quality Center by logging teh defects.
• Handled teh special characters in teh source data and there by adjusting teh code page settings in teh informatica for proper output data.
• Analysis, design and coding of teh project.
• Handled all teh phases of teh project independently.
• Test case preparation and testing
• Created Mappings using various ETL transformations.
• Created Sessions, workflows etc.
• Migration of teh informatica platform from 7 to 8.1 and unix to linux servers.
• Fixing teh bugs in teh production environment.
• Completed Ad-hoc processing orders as per teh client’s request.
• Developed new jobs for teh new requirements.
• Generating daily report for teh processed records
• Involved in gathering / interpreting end user requirements and Documentation.
• Development of jobs using PL/SQL and DataStage with UNIX Shell Scripting.
• Created number of PL/SQL Stored Procedures, Functions and Packages to implement business logic.
• Created SQL scripts to purge tables in inter after loading data into data mart.
• Involved in performance tuning for Oracle PL/SQL jobs.
• Preparing Unit Test Cases.
• Performing Developer integration testing and Developer System Testing.
• Defect resolution (Trouble ticket Management) as per teh agreed SLA.
• Played teh key role as a developer.
• Involved in code changes, Unit testing, System Integration testing and User acceptance testing
• Created Mappings using various ETL transformations.
• Created Sessions, workflows et
• Handled teh environment support activities
• Created shell scripts and Perl scripts for automation of teh several manual activities like version verification and reporting teh job completion
• Interacted with Business owners in status meeting and understand their requirements for enhancing and fixing teh current issues in teh existing system.
• Preparation of Data Dictionary based on SME (Subject Matter Expects) discussions.
• Preparation of data separation test cases and Capture test Results in Quality Center by logging teh defects.
• Handled teh special characters in teh source data and there by adjusting teh code page settings in teh informatica for proper output data.
• Designed Test Cases and Test Planes
• Involved in Tracking of Issues and maintaining standards and best practices.