SUMMARY

• Self - motivated, technologically savvy and focused with 10+ Years in ETL, BI and Cloud Technologies.
• 10+ years of experience as an Informatica Developer in Data Integration, Migration and ETL process using Informatica Power Center Suite 9.x/8.x/7.x, Power Exchange 9.x, Informatica B2B, Informatica DVO, Informatica IDQ.
• Experience working with Multiple RDBMS like Oracle, SQL server, SAP Hana and Teradata and worked on flat files.
• Designed efficient ETL mappings with Informatica PowerCenter.
• Experience creating SCD 1,2 mappings based on requirement needs using Informatica.
• Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization.
• Optimized the Solution using various performance tuning methods (SQL tuning, ETL tuning i.e. optimal configuration of transformations, Targets, Sources, Mappings and Sessions), Database tuning using Indexes, partitioning, Materialized Views)
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions.
• Experience working on scheduling tools like Tivoli, Control-M, Autosys.
• Good Project Coordination skills, onsite coordination and offshore team management.
• Good Experience of Development and Production Support.
• Proficient in Toad, SQL navigator, Teradata SQL assistant, DB Visualizer and putty.
• Knowledge on business intelligence technologies such as SAP Business objects and OBIEE.
• Have knowledge on Hadoop HDFS, MapReduce and Cloud Technologies.
• Good Domain Knowledge of Oil & Gas, Software Services, Telecom, Food Services.

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential

Responsibilities:

• Designing and developing ETL solutions using Informatica PowerCenter that follow the in-house ETL development standards.
• Managing coding for the extraction of data from all existing source systems, transforming data to industry standards and generating extract files.
• Establishing testing/quality assurance environments.
• Working with clients and system to ensure that programs and modifications are error free.
• Monitoring system performance, and other aspects of systems to identify technical problems.
• Monitoring data integrity to identify data quality problems.
• Designing and enhance the data quality improvement process including feedback to system stewards.
• Troubleshooting PowerCenter workflow errors and problems.
• Providing technical support to users.
• Assisting clients in analysing functional problems, work with clients to prioritize the data quality concerns and to communicate the need for accurate data by other constituents.
• Producing technical specifications and data mappings document; documenting the program modifications
• Documenting the solutions, the programming changes, and the problems and resolutions
• Support Informatica PowerCenter ETL -Designer, Repository Manager, Workflow Manager, Workflow Monitor, Data warehouse (Teradata) and ETL activities.
• Developed ETL workflows and provided 24*7 support.
• Work with business users and data owners to gather requirements for new or changing ETL solutions.
• Tune long running workflows/session for better performance in Prod.

Environment: Informatica PowerCenter 10.1.0/10.2.0 , Informatica B2B DX, Cleo Harmony, Informatica DVO, Informatica Web service, UNIX, Oracle 10g/12g, SQL Server, Teradata, and Control-M, Service Now.

Sr. Informatica Developer

Confidential

Responsibilities:

• Gathering business and technical requirements from the Functional and business analysts and create technical documentation.
• Use SAP Hana for creating Relevancy, Map, Target tables and views to stage data from Source and load in S4 Target systems.
• Develop Informatica reusable transformations, mappings, workflows using Informatica Powercenter 10.2.0.
• Create and load Xref tables in Oracle Database to enrich the source data.
• Create enrich templates in Concento as per the business requirements.
• Create load files to load data in SAP S/4 using LSMW, Migration Cockpit, ABAP functional module.
• Create data profiling files using Informatica developer for data profiling.
• Perform Extract, Transform, test and load data from Legacy systems into SAP S4 environments.
• Create Business objects preload and post load reports for validating data by functional and business validators.
• Resolve defects in HP- ALM that were created during the project.

Environment: Informatica Powercenter 10.2.0 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Informatica developer, Oracle 12c, Unix, Password Vault, SAP Hana, HP ALM, Concento, SAP business objects, SAP R/3 & S/4.

Sr. Informatica Developer

Confidential

Responsibilities:

• Gather business requirements for each module of the system from functional teams and develop system testing procedures.
• Provide daily support of Data Integration tools (Informatica and Sterling GIS); including scripting, configuration, integrations and administration.
• Build or update documentation to ensure standard procedures and knowledge transfer.
• Troubleshoot issues Development of workflow and other configuration and customization of the system per business requirements.
• Design, Develop and maintain ETL (Data Extraction, Transformation, and Loading) mappings using Power Center -Designer to extract the data.
• Analyze the number of Informatica jobs that are being affected by each application moving to AWS cloud.
• Created service accounts to connect to the databases and then created Informatica connections in Workflows manager and odbc.ini entries.
• Clone the Informatica mappings and workflows from on-prem production repository into AWS Informatica repository and rename the objects as per the company standards.
• Created parameter files, Unix shell scripts and staging tables when necessary.
• Heavily involved in Unit testing and validating the data. After the user validation and approval, the code was implemented in AWS production.
• Created Interface documentation and Batch job instructions in ServiceNow.
• Coordinate with Business, Informatica Admins and production control operators to implement, hold and retire the jobs in production
• Create UNIX Shell Scripts for batch scheduling and loading process.
• Create or update the new jobs for file transfer using Sterling file Gateway.
• Created control-m scripts to schedule the jobs in production through Control-M scheduling tool.

Environment: Informatica Powercenter 10.1.1(Designer, Workflow Manager, Workflow Monitor, Repository Manager), Oracle 12c, Unix, Password Vault, SFG V2.2.5, Control-M, ServiceNow, Web Job submission, Metadata.