SUMMARY

• Have overall 15 years of experience in Design, Development & Support of Data warehouse applications.
• Experience in Brio, SQL, Informatica Power Center, Informatica Power Exchange, Informatica BigData Management(BDM), Hadoop, Hive, UNIX Shell Scripting.
• Good knowledge of RDBMS with ORACLE, DB2, Teradata, Exadata, Netezza.
• Worked on XML Sources, MQ’s, Cobol Copybooks, Mainframe basics, Power Exchange sources & flat files.
• Has exposure to Troubleshooting, Debugging and fixing End User issues and Application related data issues on Production Environment.
• Good team player and leadership skills with excellent communication, analytical and mathematical skills.

PROFESSIONAL EXPERIENCE

Technical Lead

Responsibilities:

• Working on ETL tools such as Informatica power center, Informatica developer (Big data edition) & other supporting environments such as UNIX, Oracle, Main Frame, Hive to achieve the concept of single source for all enterprise data inside ELZ(Enterprise Landing Zone) Data Lake.
• Working in Big data architectures like HADOOP and HDFS to store enterprise source application data in ELZ as part of Store development & flowing data based on business criteria defined in Send Maps (Source to Target Mapping documents) to downstream systems like actimize(Pre - stage),Stage & finally CDS.
• Responding to all Business Queries and ensure efficiency in performance and availability of the applications.
• Scheduling the Informatica jobs through AUTOSYS tool.
• Preparing Technical Approach documents(TAD), Visios for Store & Send, Unit test case/Software Turnover/Production Turnover/Code review documents, performing TFS Check-in of code & related components.
• Performing Unit testing, Peer Code reviews, Architecture Team reviews, System testing support, Defect fix, Data loads, User acceptance testing as part of Business Line review and sign-off on data, Data mock-ups in lower environments. Deploying applications related to Store & Send into DEV, IT, UAT & PROD environment.
• Coordinating with offshore team(6), Providing Design/Development approaches, Technical Solutions, tracking delivery. Resolving defects, data issues, design to development gaps.
• Performing Requirement Gathering and converting the same to Technical design and obtaining Client Architecture team's approval for various modules.
• Working with Business analyst to understand and document the requirements and convert the same to Technical Design. Created Change requests & change tasks for UAT, PROD Deployment, Preparing Production Turnover documents & reviewing same with L2/L3 support for autosys dependencies, full load plan, reviewing changes to existing code or functionality of the new code.
• Coordinating with Informatica Admins, Hadoop Admins, Autosys Scheduling team(through providing JIL scripts),SOR team, NOC Event Mgmt team on thevarious change tasks for UAT and PROD deployments.
• Performed TFS Check-in of the codes corresponding to Informatica Power Center & Developer codes, Paramfiles, Hive tables, Views, Autosys JIL scripts, Hive queries etc. Working with SOR contacts onupstream data availability prior to Production Go live, raising emergency change requests in case of Production defects.

Confidential, Phoenix, Arizona

Technical Lead

Environment: Teradata, Unix, Informatica PowerCenter, ESP Scheduling Tool

Responsibilities:

• Worked as a Tech Lead and was involved in the Design, Development and Code changes of new/existing Informatica mappings/workflows.
• Involved in Shell scripting, Design document creation, Requirement Gathering.
• Analysis of data from upstream and downstream systems, making design changes in the existing environment.
• UAT, Production Code Deployment, Production Handover.
• Onsite-Offshore co-ordination, handled 6 offshore resources from onsite.

Confidential, Phoenix, Arizona

Technical Lead

Environment: Netezza, Unix, Informatica PowerCenter, Tidal Scheduling Tool

Responsibilities:

• Worked as a Tech Lead and was involved in the Design, Development and Code changes of new/existing Informatica mappings/workflows.
• Involved in Shell scripting, creation of Tidal jobs etc.
• Analysis of data from upstream and downstream systems, making design changes in the existing environment.
• Unit Testing, Production Code Deployment, Operations Review.

Confidential, Plano, Texas

Technical Lead

Environment: Oracle 9i/10G/Exadata, Unix, Informatica PWX, Informatica 9.0

Responsibilities:

• Worked as a Tech Lead and was involved in the Design, Development and Code changes of existing Informatica mappings/workflows.
• Involved in Shell scripting, creation of Unix jobs etc.
• Analysis of data from upstream and downstream systems, making design changes in the existing environment.
• Unit Testing, Integration testing and updating of the User Stories on Jira along with the Test case documents.
• Provided KT to new recruits in the team, conducting interviews to recruit candidates into the team.
• Creation of SQL queries.performance tuning of workflows and queries.
• Knowledge of dimension tables, Data Modelling basics, Partitioning etc.

Confidential

ETL Development

Environment: Informatica, Autosys, SQL, Oracle, Unix

Responsibilities:

• Worked as individual developer and was involved in developing Informatica mapping which makes use of Informatica web services.
• The change data captured based on the time stamp from Oracle database tables needs to be loaded to an XML target.
• It is expected that the data will be extracted, transformed and pushed via the Eclipse Organization web service into Eclipse on a daily basis, during a period of low activity.
• To do this, Informatica and its associated Web Services was used Creation of HLD’s, LLD’s, Test Cases and data analysis.

Confidential

ETL Support/Enhancement

Environment: Oracle 9i/10G, Informatica 8.6,Ctrl-M

Responsibilities:

• Performing Production Support activities along with handling a team of 3 members.
• Analysis of complex Informatica mappings for issue resolution and root cause analysis.
• Conducting Team meetings, Sending of Weekly status reports.
• Creation of Resource Loading Sheets
• Providing estimates on the no. of resources and efforts in hours required for the ISR’s handled.

Confidential

ETL Developer (Oracle DWH)

Environment: Oracle 9i/10G, HP-UX, PL/SQL, Unix Shell Scripts, Ctrl-MWeb OSA & OBIEE

Responsibilities:

• Involved in integrating the different source systems in the Source One data warehouse.
• Performing System Integration testing.
• Data discrepancy investigations as part of BAT signoff.
• Creating Unit Test Cases.
• Testing the code on UAT before MTP.
• Moving the code from Development to Deployment and finally to Production Environment.
• Creation of SRS, HLD, LLD, Migration list, SIT design documents etc
• Handled the Software Quality Assurance role for the project as well
• Constant Interaction with Client Counterparts for understanding requirements, Upstream and Downstream application owners to determine impact to downstream applications already running in CDW etc. due to code changes.