PROFESSIONAL ACUMEN:

• Over 8 years of IT experience in Analysis , Design , Development , Implementation and Troubleshooting in the areas of Data warehousing Methodologies using Informatica , DataStage,Talend, Oracle , DB2 , Unix Scripting and Python.
• Experience in data integration from different source systems like database, mainframe, XML, webservices , using ETL process.
• Dimensional modelling using Star schema and Snowflake schema .
• Extensively used the Data Warehousing concepts like Slowly Changing Dimensions, Facts.
• Expertise in Data Profiling and Cleansing activities.
• Experience in Extraction, Transformation and Loading (ETL) data from various data sources into Data Marts and Data Warehouse using Informatica and Talned components .
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Knowledge on Big Data concepts Hadoop.
• Python scripting language for automation.
• Extensively used Unix Shell scripting in interacting with the multiple Databases, automation of ETL processes, error handling, to perform analysis and troubleshoot the source data.
• Very good knowledge in writing complex SQL queries.
• Performance tuning technique for query optimization as well as for Informatica code tuning.
• Good knowledge in PL - SQL stored proc and functions.
• Experienced in preparing the various documents like Requirement document, high level and low level design documents Business Mapping documents, Change request documents and Implementation documents.
• Expertise in developing tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Proactively identify business problems that can be addressed with IT solutions and own delivery from concept to implementation and advising technical groups on Database and ETL best practices.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Worked in Waterfall as well as Agile environment.

ETL-Data Warehousing: Informatica Power Center 9.X, Informatica Power Exchnage 9.X, Talend. IBM DataStage 11.3

Databases: Oracle 11g, MS SQL server 2008, DB2,

Languages/web: Python, SQL, PL/SQL,UNIX Shell Scripting,

Scheduling Tools: IBM Tivoli Workload Scheduler

Testing Tools: HP Quality Center

SDLC Model: Agile, Water Fall.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Developer

Responsibilities:

• Understanding the existing components in HEIDS yearly report generation and all the components related to HEIDS.
• Work with Business Analysts, Business report users to understand the requirement for the HEIDS /HPRO reports.
• Work with various cross commit business groups which acts as source for various types of data.
• Integrate Data from various sources like, flat files, data bases and perform business logic in ETL tool DataStage 11.3.
• Develop DataStage jobs to integrate the data and generate files and load to different data base tables.
• Worked on scheduling all the code components in TWS (Tivoli Workload Scheduler) based on frequency and compatible time for business.
• Carrying out the project work by contributing ideas, opinions and new information, review meeting with the team members & responsible for the work undertaken by team members.
• Create UNIX shell scripts to fulfill various business functionalities.

Environment: Oracle 11g,, IBM Data Stage 11.3,Unix shell scripting, MS office, TWS, Windows 7, Linux.

Confidential

Sr Data warehouse ETL-Engineer-/Infoamtica

Responsibilities:

• Involved in Data modelling and mapping specifications to create LDM and PDM.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Extracting data from the database by writing SQL queries, PL/SQL procedure and ETL Informatica tool.
• Pulled data from multiple data sources and applied required business functionality using ETL Informatica tool.
• Developed user-defined formats and informatics to integrate the data and created visually compelling and actionable interactive reports and dashboards.
• Involved in designing of code and set up timelines for the project.
• Worked on scheduling all the code components in TWS (Tivoli Workload Scheduler) based on frequency and compatible time for business.
• Use experience and knowledge of line of business and trends to determine materiality of variances in the analysis and reporting process
• Carrying out the project work by contributing ideas, opinions and new information, review meeting with the team members & responsible for the work undertaken by team members.

Environment: Oracle 11g, DB2, Infromatica Power Center 9.6, Informatica Power Exchange 9.6, Unix shell scripting, python Scripting, MS office, TWS, Windows 7, Linux.

Confidential

Data warehouse Architect / SR.ETL(Informatica) Developer

Responsibilities:

• Involved in Data modelling and mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Extracting data from the database by writing SQL queries, PL/SQL procedure and ETL Informatica.
• Pulled data from multiple data sources like Oracle, Mainframe, Teradata, flat files, web services and applied required business functionality using ETL Informatica.
• Created workflows and developed Informatica mappings for Data cleaning, Validation, and Analysis.
• Developed user-defined formats and informatics to integrate the data and created visually compelling and actionable interactive reports and dashboards.
• Involved in designing of code and set up timelines for the project.
• Worked on scheduling all the code components in TWS (Tivoli Workload Scheduler) based on frequency and compatible time for business.
• Use experience and knowledge of line of business and trends to determine materiality of variances in the analysis and reporting process
• Carrying out the project work by contributing ideas, opinions and new information, review meeting with the team members & responsible for the work undertaken by team members.

Environment: Oracle 11g, DB2, Informatica Power Center, Informatica Power Exchange, Unix shell scripting, Python Scripting, MS office, TWS, Windows 7, Linux.

Confidential

SR data warehouse Lead /ETL (Informatica) Developer

Responsibilities:

• Understanding the existing components in legacy and replicate the same business logic of the product in ETL Informatica.
• Worked with data architects to come up with the new data model.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Create UNIX shell scripts to fulfill various business functionalities.
• Extracting data from the database by writing SQL queries, PL/SQL procedure and ETL Informatica.
• Pulled data from multiple data sources like Oracle, Mainframe, Teradata, flat files, web services and applied required business functionality using ETL Informatica.
• Created workflows and developed Informatica mappings for Data cleaning, Validation, and Analysis .
• Worked on scheduling all the code components in TWS (Tivoli Workload Scheduler) based on frequency and compatible time for business.

Environment: - Oracle 11g, DB2, Informatica Power Center, Informatica Power Exchange, Unix shell scripting, MS office, TWS, Windows 7, Linux.

Confidential

Software engineer / Data warehouse Analyst/ETL developer

Responsibilities:

• Proactively identify business problems that can be addressed with IT solutions and own delivery from concept to implementation and advising technical groups on Database and ETL best practices.
• Get the business requirements from various sources like business docs, Functional teams, and SME’s and report users.
• Understanding the existing components in legacy and replicate the same business logic of the product in ETL Informatica tool.
• Worked with data architects to come up with the new data model.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Create UNIX shell scripts to fulfill various business validation purposes.
• Extracting data from the database by writing SQL queries, PL/SQL procedure and ETL Informatica tool.
• Pulled data from multiple data sources like Oracle, Teradata, flat files, web services and applied required business functionality using ETL Informatica.
• Worked on scheduling all the code components in TWS (Tivoli WorkLoad Scheduler) based on frequency and compatible time for business.

Environment DB2, Oracle 11g, Informatica 9.X, Unix shell scripting, MS office, TWS, Windows 7, Linux