SUMMARY

• 6+ years of IT Experience in Data Warehousing, Database Design, Development and Implementation of Data Warehouse & Data Marts using ETL Tools and ETL Processes in various business domains like finance, telecom, manufacturing, insurance and health care industries.
• Experience in designing and implementing data warehouse applications, mainly in ETL processes using Informatica Power Center v10.x/v9.x/v8.6.1/v8.1 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Consultant), Repository Manager, Repository Server, Workflow Manager & Workflow Monitor.
• Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large - scale Data warehouses using Informatica Power Center.
• Extensively used ETL methodologies for supporting Data Extraction, Transformation and Loading process, in a corporate-wide-ETL solution using Informatica Power Center.
• Extensively worked on developing Informatica Designer, Workflow manager and Workflow monitor for data loads.
• Extensive experience in using various Informatica Designer Tools such as Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer.
• Extensive knowledge of data warehouse approaches - Top down (Inmon’s approach) and Bottom up (Kimball’s approach), methodologies- Star Schema, Snowflake.
• Extensive experience in Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in E-commerce software, Utility, Pharmaceutical, Health Care, Insurance, Financial, Manufacturing and Banking industries.
• Experience in development and maintenance of SQL, PL/SQL, Stored procedures, functions, analytic functions, constraints, indexes and triggers.
• Strong understanding of Dimensional Modeling, OLAP, Star, Snowflake Schema, Fact and Dimensional tables and DW concepts and Normalization/De-normalization.
• Experience in using update strategies, incremental loads, and implementing Slowly Changing Dimensions of Type I and Type II
• Experienced in IDQ (9X, 9.5.1) handing LDO’s PDO’s & some of the transformation to cleanse and profile the incoming data by using Standardizer, Labeler, Parser, Address Validator Transformations of experience in using different versions of Oracle database like 11g/10g/9i/8i.
• Excellent working knowledge of shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX.
• Proficient with Informatica Data Quality (IDQ) for cleanup and massaging at staging area.
• Experience in ETL development process using Informatica for Data Warehousing, Data migration and Production support.
• Experience in both Waterfall and Agile SDLC methodologies.
• Data modeling experience in creating Conceptual, Logical and Physical Data Models using ERwin Data Modeler.
• Experience with TOAD, SQL Developer database tools to query, test, modify, analyze data, create indexes, and compare data from different schemas.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Knowledge in Data Analyzer tools like Informatica Power Exchange (Power Connect) to capture the changed data.
• Proficiency in data warehousing techniques for data cleansing, surrogate key assignment and Change data capture (CDC).
• Experience in integration of various data sources like Oracle, DB2, Flat Files and XML Files into ODS and good knowledge on Teradata 12.0/13.0, SQL Server 2000/2005/2008 and MS Access 2003/2007.
• Hands on experience in MDM development. Involved in the designing of Landing, Staging and Base tables in Informatica MDM.
• Created MDM mapping and configured match and merge rules to integrate the data received from different sources.
• 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, Procedures and functions).
• Extensively used Autosys, Tidal, control-M for scheduling the UNIX shell scripts and Informatica workflows.
• Extensive knowledge in all areas of Project Life Cycle and Development.
• Strong analytical, verbal, written and interpersonal skills.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, SQL Server 2005/2008, MS Access, DB2 8.2, Teradata

Operating Systems: Unix (Putty), Windows

Languages: PL/SQL, T-SQL, UNIX Shell Scripting

Tools: Informatica Power center v10.x/v9.x/v8.6.1/v8.1, Informatica IDQ, Power Center, Power Exchange, MDM (Master Data Management), Informatica Data Explorer (IDE), TOAD.

OLAP: OBIEE 10.1.3.X, 11g, Siebel Analytics 7.8/7.7, COGNOS 6.x (Framework Manager, Report Studio)

Scheduling Tools: Autosys, Informatica Scheduler, control- M, Active Batch

Methodologies: Star Schema, Snow Flake Schema, Ralph Kimball Methodology, Data Mart, ERwin

Reporting Tools: Business Objects, COGNOS, OBIEE AND MicroStrategy.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Developer

Responsibilities:

• Led development of the project using Informatica 10.4, MS SQL Server, Oracle, Autosys, Workbench, Unix, Salesforce, Git, Jenkins and JIRA.
• Extracted high volume of datasets from flat files, tables, Salesforce objects and SQL Server tables using Informatica ETL mappings and loaded into the Salesforce objects, flat files and tables.
• Involved in Agile software development methodology including design, ETL strategy, troubleshoot reporting and identifying facts and dimensions for various projects.
• Developed complex data mappings between the source systems and warehouse components to meet the business/project needs in Informatica 10.4.
• Developed ETL techniques to ensure conformity, compliance with the business standards, processes, regulations, lack of redundancy and translate the business rules and functional requirements.
• Performed ETL test plans, test cases, test scripts, test procedures, assumptions and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing.
• Used Apex Data loader to read/write csv files to Salesforce objects and wrote complex SOQL queries in Salesforce/Workbench.
• Worked on migrating Salesforce objects from dev to test and test to prod environments using org sandbox credentials.
• Involved in performance tuning at the mapping, session, source and target level for data loading.
• Created tables, views and stored procedures in MS SQL Server and Oracle.
• Developed and modified Unix shell scripts as part of the ETL processes.
• Used Git for version control and Jenkins for Continuous Integration and Continuous Deployment (CI/CD).
• Used JIRA as the issue tracking and bug tracking tool.
• Developed and scheduled the jobs using Autosys scheduling tool.

Environment: Informatica 10.4, Oracle 19c, MS SQL Server 2016, Autosys, Salesforce, Workbench, Git, Jenkins, JIRA, Unix.

Confidential, Nashville, TN

Sr. Informatica Developer/ Specialist

Responsibilities:

• Assisted in gathering business requirements and document design for all impacted data warehouse projects.
• Led development of the project using Informatica 10.2, Teradata, MS SQL Server, Active Batch and Java.
• Involved in full cycle development including design, ETL strategy, troubleshoot reporting and identifying facts and dimensions for various projects.
• Created complex mappings, mapplets, database objects and workflow to meet the business/project needs in Informatica 10.1.
• Designed and developed the logic for handling Slowly Changing Dimension (SCD) processes.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Designed and developed error handling methods and implemented throughout the mappings.
• Involved in performance tuning at the mapping, session, source and target level for data loading.
• Created tables, views and stored procedures in MS SQL Server and Teradata.
• Deployed the jobs in Jenkins and Git.
• Developed and scheduled the jobs on Active Batch.
• Worked with cutting edge AWS technologies such as Hadoop and Spark. Acted as subject matter expert on AWS and other cloud providers.

Environment: Informatica 10.2, Teradata 16.20, MS SQL Server 2008/2012, Active Batch, PL/SQL Developer

Confidential, Louisville, CO

Sr. ETL Developer

Responsibilities:

• Mentored team members on ETL development.
• Assisted in code and data migration as the Informatica system is upgraded from 9.6 to 10.2.
• Analyzed and thoroughly studied data sources and different development environments within the organization.
• Extensively worked with various flat files (fixed width, delimited), applying the business logic and then loading them to the SQL Server database.
• Developed ETL mappings & extensively worked with source qualifier, filter, joiner, expression, aggregator, router, sequence generator, update strategy and Java transformations.
• Developed database components & stored procedures by using PL/SQL to support data integration.
• Involved in migration of the maps from IDQ (Informatica Data Quality) to Power Center.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records and provide information on how to proceed with ETL processes.
• Worked closely with business for requirement gathering and to understand the project needs.
• Performed DDL statements for the RDBMS (Relational Database Management System).
• Extensively worked on data conversion and data cleansing.
• Supported go live activities and ensured successful deployment to operations.
• Provided insights into industry best practices.

Environment: Informatica 9.6/10.2, Informatica Data Quality(IDQ), Oracle 13g, MS SQL Server 2016, UNIX, Flat Files, WinSCP, Informatica scheduler.