OBJECTIVE:

To obtain a challenging and rewarding software engineer position where I can use the knowledge acquired through professional experience and educational background to help the company reach its goals.

SUMMARY:

• Around 7 Years of expe rience in Info rmatica application development wi th a strong backgr ound i n ETL design, development and maintenance using Informatica Power Center 9.6/9.1/8.6.1
• Around 3 years of Business Discovery, Data Discovery & Analysis, ETL Design, Development, Testing, Implementation and Troubleshooting in the field of Data warehousing development with Informatica and Teradata.
• Strong experience as ETL design engineer for 3 years across various line of business applications.
• Expertise in migration of Informatica power center from one version to other version, code development and deployment.
• Experience in numerous performance optimization techniques using Informatica.
• Experience in dealing Slowly Changing Dimensions, PWX CDC (Change data Capture)
• Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server and Teradata.
• Well - acquainted with Informatica Designer Components - Source Analyzer, Transformation Developer, Mapplets and Mapping Designer
• Experienced in developing workflows, sessions, command tasks, complex mappings, Mapplets and all types transformations with excellent performance technique.
• Experience in migration of Data warehouse from Teradata to Oracle using Informatica.
• Expertise in utilizi ng scheduli ng tools like Cont rol M and TWS
• Good knowl edge in middleware t ools like web MQ ser ies, MFT and Datapower.
• Experience i n UNIX shell scripting, FTP and file management i n various U NIX
• Extensive expe rience i n performance tuni ng of ETL process. R educed th e executi on tim e significantl y for huge volumes of data du ring compan y merge r projects and many lon g running jobs in producti on by impl ementin g Pushdown op timization .
• Speciali zed in design ing distri buted /ETL/Informati ca batches, Job fl ows, schedule, NFR ’s Operati onal needs, an d Restart ability and data quali ty imp rovements.
• Expertise in documentat ions, creatin g very detail ed design document s (LLD, HLD, Visi o Job Linkage an d etc.) and supp ort relat ed documents.
• Expertise in Re-Engin eering an d Optimizati on, minor to major enhancement s, reusable transf ormations, Cost Benefit Analysis an d new proposal s.
• Experienced i n implemen ting Automated Err or Reproc essing (AER ) to ensure exceptions and errors are captu red to mai ntain the Integri ty between S ource and Target system s.
• Experience i n defini ng testing strategi es, creatin g test cases fo r unit, functional and integrati on testing and getting UAT sign off from Bu siness.
• Being th e lead of Data Integrati on Governance, have revi ewed and appr oved all ETL appli cation design . And have main tained ETL design standards acros s the organiza tion.
• Experienced i n project esti mation and resource mana gement, devel oped many
• ETL int erfaces and experti se in SDLC del iverabl es. Involved in Desig n and Implementati on reviews an d transit ion to supp ort team.
• Strong experi ence in Knowledge man agement, Inc ident Man agement and
• Change Man agement.
• Very Strong co mmuni cation and leadership skills, inter per sonal and presentati on skill s.
• Ability to work in dependentl y with customers and a ct as effi cient coordinat or for onsi te-offshore res ource mod el. Leadin g the team off 20 people at offshore and 2 on onsi te.
• Highly motiv ated individu al with excellent team bui lding an d playing skill s

TECHNICAL SKILLS:

ETL Tools: Informati ca Power Center 9.x, 8.x, Informati ca Power Exch ang e for Main frame and CDC, Informatica Support Cons ole.

Schedulers: BMC C ontrol M and IBM TWS.

Programmin g Lang u ages: C, JA VA, SQL, HTML and X ML

Scripting: UN IX/Linux Scriptin g

Databases: Oracle, SQL Se rver, DB2 UDB/Z OS, Teradata

Operating S ystem: Wind ows NT/2000, U NIX, Lin ux, Red hat, AIX

Tools: & Ut i lities SQL* plu s, PL/SQL developer, Win SCP, Lotus notes, Outl ook, Ecli pse, WebSphere M Q, Manage n ow and Service Now .

Version Cont rol Tools: Informatica Team Based development, G IT, Win CVS

Ot hers: MS Vi sio, MS Pow er Point, MS w ord, MS Excel

PROFESSIONAL EXPERIENCE:

ETL Technical Lead

Confidential, Minneapolis, MN

Responsibilities:

• Working as a ETL Design Lead and responsible for designing the ETL components, shell scripts and schedule for the Project.
• Interaction with business users/support teams on requirement gathering and specifications.
• High level & low-level ETL flow design
• Involved in detailed technical discussions
• Create mappings employing various transformations, filters, joiners, lookup, SQL overrides etc. to load data from multiple databases into Warehouses
• Creation of Sessions and Workflows to schedule these mappings.
• Creation of Unit Test cases and Integration test cases
• Perform unit testing of these Workflows from source to staging and staging to Warehouse
• Analysis & fix on QA defects
• Review the Informatica Code, scripts, Unit Test Cases & Results with the Developers.
• Involved in Unit testing and UAT defect fixing.
• Involved in sessions partitioning and mappings performance tuning.
• QA & Production deployment.

Environment: Informatica Power Center 9.6.1, SQL Server, TWS, Power Center D esigner, Re pository Manager, Workflow Manager, Workflow Monitor, Mainframe

Lead Informatica Developer

Confidential, Minneapolis, MN

Responsibilities:

• Responsible for designing the ETL Strategy & Architecture for Salesforce.
• Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the BI.
• Establish and enforce technical standards for deliverables of projects.
• High level & low-level ETL flow design and involved in detailed technical discussions
• Functional KT to the QA team.
• Involved in Informatica Code review, Unit Test Cases & Results with the Developers.
• Organize daily technical discussions with the Onsite and offshore resources.
• Perform Analysis, Design, Build, Testing, implementation and warranty support and respective deliverables and coordination with all cross-commit teams.
• Develop Unix Shell scripts, stored procs, Informatica workflows, sessions, mappings, transformations, mapplets, and reusable transformations, utilize appropriate caches and performance techniques. Informatica pre-session, post session to call the required scripts/SQLs.
• Involve data architects, system architects during design and come up with approach for extract, transform and load methods.
• Develop data model diagrams, job linkage and process link diagrams.
• Develop and Implement jobs in TWS, deliver SDLC documents, conduct reviews and walkthroughs, test sign off and manage deliverables.
• Implement Oracle table partition for faster load and better performance. Implement dynamic cache and other Informatica recommended performance techniques.
• Utilize Staging table, create delta files (new & changed) to downstream systems
• Implement router and update strategy and load salesforce Objects. Implement INSERT, UPDATE and DELETE methods.
• Implement Restartability, precheck, duplicate file check, post balancing check, empty file check to improve data quality and Integrity between the systems.
• Follow change management process and perform Informatica Code, Data Map and UNIX code migration from lower environment to production.

Environment: Informatica Power Center 9.1 and 9.6.1, Salesforce Objects, Oracle, TWS, Power Center Desig ner, Power Exchang e, Repository Man ager, Workflow Manager, Workflow Monitor, Mainfra me, Flat File.

Lead Informat ica Developer

Confidential, Minneapoli s, MN

Responsibilities:

• Work with Data Archi tects and Busi ness to discuss data model diagrams
• Identi fying key fields i n all the warehouse tables whi ch the busi ness wanted to valid ate.
• Develop the High Level, Low Level design documents, Job Linkage Diagrams, Data Model Diagrams etc.
• Develop the mappings and scripts along with the Nonfunctional Requirements (NFR) components like Restart ability, pre-check, duplicate file check and post balancing check, empty file check to improve data quality and Integrity between the systems.
• Requirement gathering and analysis of business requirements from client.
• Converting the business requirement documents into technical specification documents.
• Interacting with the business groups for developing the business model and delivering end to end solutions through periodic status meetings.
• Development the code and provide walk through’ s to the support teams and moving the code to higher environments following the change management process
• Checking the code for adherence of standards.
• Testing (Unit, System and Integration Testing)
• Quality Assurance and Final Delivery

Environment: Informatica Power Center 9.1, Linux, TWS, Power Center Desig ner, Power Exchang e, Repository Man ager, Workflow Manager, Workflow Monitor, Mainfra me, XML, DB2

Senior Developer

Confidential

Responsibilities:

• Identi fy dependency and group appli cations by pha se to defin e timeline for mig ration.
• Prepare pl an where Info rmatica and Schedule mi gration (Control M-TWS ) happens at same time to r educe cost and ti me.
• Change scri pt, pram fil es and all hard-coded values in 9.1 ser vers, Copy al l session persi stent or bat ch values li ke sequence nu mber to the mi grated session.
• Create new job stream, new jobs i n TWS, ensures p roperti es of the jobs ar e main tained by doing regression testi ng. Al so, create new event rules in TWS for better moni toring.
• Develop addi tional scripts/Inf ormatica w orkflow s which are r equired to me et the operation al need. R egression t esting in lower environment for sche dul e testing and performanc e testing.
• Perform Info rmatica Co de, Data Map and U NIX code mi gration from on e environment to another envi ronment i ncluding Producti on and do post val idati on.
• Perform dry run testi ng (pre-prod ) to ensur e schedul es are correct and al l dependenci es are resol ved and jobs are t riggerin g automati cally in new schedul er.

Environment: Informatica Power Center 9.1, Teradata, Red Hat Linux, Unix, TWS, Control-M, Power Center Designer, Power Exchange, Repository Manager, Workflow Manager, Workflow Monitor, Mainframe, XML, Oracle, DB2, SQL Server.

ETL Data-warehouse Developer

Confidential

Responsibilities:

• Requirement gathering and analysis of business requirements from clients
• Converting the business requirement documents into technical specification documents.
• Developed the High Level, Low Level design documents
• Developed the mappings and scripts along with the Nonfunctional Requirements (NFR) components like Restart ability, pre-check, duplicate file check and post balancing check, empty file check to improve data quality and Integrity between the systems.
• Development of code and provide walk through’ s to the support teams and moving the code to higher environments following the change management process
• Checking the code for adherence of standards.
• Testing (Unit, System and Integration Testing)
• Quality Assurance and Final Delivery

Environment: Informatica Power Center 9.1, Unix, TWS, Teradata, Power Center Desig ner, Power Exchang e, Mapping designer, Workflow Manager, Workflow Monitor, Mainfra me, XML