EXPERIENCE SUMMARY:

• 9+ years of experience in Informatica PowerCentre, Informatica Developer 10.X, Informatica cloud, Redshift, AWS S3, Oracle SQL PL/SQL programming, Netezza, UNIX with experience in BIG data implementation using Apache Hadoop and python.
• Extensive experience in Data mart and Data warehouse Design and development.
• Strong Experience in dimension modelling and Star schema implementation
• Extensive ETL and Data warehousing Experience
• End to end project experience delivery experience starting from requirement gathering to development, testing, delivery and hyper care.
• Strong experience in working on Amazon Redshift.
• Extensively worked with Oracle PL/SQL Stored Procedures, Triggers, Functions, Packages and also involved in Query Optimization.
• Ability to write complex SQLs needed for ETL jobs and analysing data, and is proficient and worked with databases like Oracle 11g/10g/9i,Netezza, SQL Server 2008/2005, My SQL, Flat Files and COBOL files .
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
• Strong experience in working on Hadoop hive, pig and managing files in HDFS.
• Extensive experience in Insurance, Banking, Financial and Telecom domains.
• Experienced in OLTP/OLAP system study, analysis and developing
• Knowledge of Qlikview reporting tool.
• Good Experience in leading and managing teams.

TECHNICAL SKILLS:

Tools: Windows (NT/XP/2000), LINUX,UNIIX

Programming Languages: PL/SQL, SQL, Shell Programming

DBMS: Oracle 9i/10g, Microsoft SQL Server 2005

Tools: Informatica PowerCentre 9.x,Control - M,Qlikview

Database Tools: SQL Developer,Netezza

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Leading and Managing the project from requirement analysis to delivery
• Developed and maintained DataMart’s in Redshift and oracle using the star schema approach.
• Created dimension model for project implementation.
• Implemented performance improvement techniques in Redshift and oracle
• Analysing, designing and developing of ETL project.
• Developed design document for ETL process.
• Moving data from S3 to oracle and then to Redshift.
• Develop sql, pl/sql code required for the implementation.
• Develop Unix shell scripting code as per the requirement
• Extracted data from various sources like Flat files, Oracle and loaded it into Target systems using Informatica developer

Informatica Developer

Confidential

Responsibilities:

• Leading and Managing the project from requirement analysis to delivery
• Developing and maintaining DataMart and Data Warehouse
• Created dimension models for review and implementation
• Analysing, designing and developing of ETL project.
• Developed design document for ETL process.
• Responsible for designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Build data pipelines
• Moving data from database to HDFS.
• Loading data in Hive
• Transforming data using Hive and Pig.
• Develop sql.pl/sql code required for the implementation.
• Develop Unix shell scripting code as per the requirement
• Extracted data from various sources like Flat files, Oracle and loaded it into Target systems using Informatica 9.5.

Confidential

Responsibilities:

• Worked on the data warehousing project for the US based
• Financial institution's Confidential group. the vision f the project was to create a comprehensive and aggregated view of risk data to allow assessment and
• Analytics across the financial instruments. in this project
• We used Hadoop, Redshift and tableau technologies.
• I had worked on analysing, designing and building extraction, transformation and load processes for
• Building a data lake. built data models in redshift
• To help reporting layer to read data faster.
• Transform data from Hadoop and load into final tables in the data warehouse.

Confidential

Responsibilities:

• Requirement analysis and preparation of mapping document.
• Maintaining and developing existing DataMart model
• Analysing, designing and developing of ETL project.
• Developed design document for ETL process.
• Responsible for designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Moving data from database to HDFS.
• Loading data in Hive
• Transforming data using Hive and Pig.
• Develop sql.pl/sql block required for the implementation.
• Develop Unix shell scripting code as per the requirement
• Extracted data from various sources like Flat files, Oracle and loaded it into Target systems using Informatica 9.5.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Writing Oracle Stored Procedures, Triggers, and Packages to effectively in corporate Business logic and providing security by wrapping the contents.
• Handling PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification
• Optimization of the query and performance tuning.

Confidential

Responsibilities:

• Analysing, designing and developing Extraction, Transformation and Load (ETL) processes for a data warehousing project.
• Developed design document for ETL process.
• Responsible for designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Extracted data from various sources like Flat files, Oracle and loaded it into Target systems using Informatica 9.1.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator, expression transformation to build business rules to load data.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.

Confidential

Responsibilities:

• Connecting to Oracle/my sql database from Apcahe Sqoop
• Migrating data from oracle database and flat files to Hadoop HDFS.
• Creating Tables in Hadoop Hive
• Writing Queries in Hadoop Hive
• Transferring data from Hive to Oracle.

Confidential

Informatica and Database Developer

Responsibilities:

• Creating and Modifying Stored Proc, Views and Triggers
• Creating DB schemas(tables,indexes)
• Altering table Structure
• Involved in reviewing Business requirement and preparing design documents.
• Preparing Design Documents with Approach and DFD diagrams.
• Conducting Code reviews sessions
• QA/UAT/PROD Supports.
• Requirement gathering & high/low level estimations
• Preparing Low level and high level design.
• Design of ETL framework & solutions. (Mappings,Mapplet,Worklet,Workflow)
• Involved in coding for creating/enhancing the informatica mappings and workflows, also created/maintained UNIX shell scripts to execute the informatica workflows.
• End to end ETL/Oracle/Unix development.
• Conducting Code reviews sessions.
• 7. QA/UAT/PROD Supports.