5+ years of IT experience in Data warehousing with emphasis on Business Requirements, Application Design and Development, Data Integration, IDQ, implementation and maintenance of Data Warehouse.
Involved in all phases of SDLC from analysis and planning to development and deployment.
Experience in OLTP Modeling and OLAP Dimensional modeling (Star and Snow Flake) using ERWIN (conceptual, logical and physical data models).
Strong experience developing complex mappings using transformations like Source Qualifier, Filter, Expression, Joiner, Router, Union, Unconnected / Connected Lookups and Aggregator.
Experience in Slowly Changing Dimensions (Type 1, Type 2 and Type 3), OLTP, OLAP and Surrogate keys.
Used IDQ to do data profiling of the master data. Used Informatica Analyst to get an overview of the accuracy of the data and percentage populated.
Responsible to provide technical guidance in ETL and Netezza on multiple projects
Experience in using software methodologies such as Waterfall and Agile(SCRUM).
Experienced in executing complex queries using stored procedures, Triggers, Cursors, User Defined Functions using T-SQL.
Developed Cloud mappings to extract the data for different regions
Proficient in writing the Stored Procedures, Triggers, Functions, Indexed Views.
Designed and Developed ETL logic for implementing CDC (Change Data Capture).
Extensive experience with all tasks in workflow manager to implement job control in Informatica to support dependencies in loading data in target systems including Pre-Post session commands/SQL.
Experience in working with Azure cloud data integration with SQL Database
Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
Scheduled the ETL jobs daily, Weekly and monthly based on the business requirement in Autosys
Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work effectively as a team member as well as independently.
ENVIRONMENTS: Windows, UNIX, Linux, Mainframes
ETL Tools: Informatica, SQL Server SSIS,
DATABASES: Oracle11g/10g, SQL Server, Teradata, TOAD, VSAM
BI TOOLS: COGNOS, Tableau, Business Objects, SSRS
DLLR, Baltimore, MD Jan 2017 – Present
ETL Informatica Developer/Admin
Worked with Product Analyst and business users to clarify requirements and translate the requirement into technical specifications. Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
Built Informatica servers and setup the Development, QA and PROD environments.
Pulled data from VSAM files on Mainframes and loaded into SQL Server.
Created Informatica Instance on Microsoft Azure Server.
Design/developed and managed Power Center upgrades, Migrate ETL code from Informatica, Integrate and managed workload of Power Exchange CDC.
Used Informatica Power Exchange for loading/retrieving data from mainframe systems.
Experience in building the Azure environment and ETL data integration into cloud and AWS
Good experience in working with agile methodologies and attending the scrum meetings
Created and scheduled Sessions and Batches through the Informatica Server Manager.
Experience with enterprise repository tools, data modeling tools, data vault, data mapping tools and data profiling tools.
Performed thorough data profiling to understand the quality of source data and to find data issues using IDQ.
Created partitions, SQL over ride in source qualifier, session partitions for improving performance.
Tuned SQL statements, Informatica mappings, used Informatica parallelism options to speed up data loading to meet defined SLA
Designed and documented validation rules, error handling and test strategy of ETL process.
Tuned Informatica mappings/sessions for better ETL performance by eliminating bottlenecks.
Extracted data from multiple data sources like, DB2, VSAM file (Binary) on Mainframes and loaded into staging tables.
Used Workflow Manager for creating, validating, testing and running sequential and concurrent batches.
Analyzed workflow, session, event and error logs for trouble shooting Informatica ETL process.
Worked with Informatica Debugger to debug the mappings in Informatica Designer.
Involved in creating test plans, test cases to unit test Informatica mappings, sessions and workflows.
Migrated Informatica ETL application and Database objects through various environments such as Development, Testing and Production environments.
Environment: Informatica Power Center, IDQ, DB2, Mainframes, AWS, Cloud, SQL Server Management Studio, Oracle, Windows, Netezza, UNIX Shell Script, Microsoft Azure.
Westfield Insurance, Westfield, OH Jun 2015 – Dec 2016
BI / ETL Developer
Designed ETL functional specifications and converted them into technical specifications.
Participating in user meetings, gathering requirements, discussing the data issues with end users. Translating user inputs into ETL design docs.
Preparing High Level Design documents.
Preparing source to target mappings documents and mappings development.
ETL mappings development & bug fixing.
Modifying Mapping workflows using Informatica PowerCenter as per the Change Requests raised by client
Proficient in Normalization and De-Normalization of existing tables for faster query retrieval.
Used various transformations like filter, expression, sequence generator, update strategy, joiner, router, and aggregator.
Designed and documented the error-handling strategy in the ETL load process. Prepared the complete ETL specification document for all the ETL flows.
Developed monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.
Created test data and unit test cases to ensure successful data loading process.
Transferred information to a new version of Oracle Database and converted all programs to graphic version in Oracle.
Analyzed, designed and developed one module for support of loading process.
Restructured company processes including inventory reports, Pay-out, and invoice payments. Technical Documentation.
Configuring and running sessions, tasks, and workflows.
Migrating Informatica workflows/folders from one environment to another.
Responsible for maintaining repository backups and their restorations.
Defined relationships and cardinality between different database tables.
Worked with DBA to setup the new Databases and Modify Databases for Reporting Models.
Created Crosstab’s to display underlying data based on various graphs and charts created for further data analysis.
Deployed packages from a development environment to test environment.
Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.
Environment: Informatica Power Center, Oracle, Sybase, Delimiter files, Power view, Windows.
Laureate Education, Baltimore, MD Mar 2013 – Jun 2015
Collaborated with Project Manager, Tech Lead, Developers, QA teams and Business SMEs to ensure delivered solutions optimally support the achievement of business outcomes.
Designed and developed ETL Processes based on business rules, job control mechanism using Informatica Power Center.
Data Warehouse Data modeling based on the client requirement using Erwin (Conceptual, Logical and Physical Data Modeling).
Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, Lookup, update strategy and stored procedure transformations.
Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
Re-engineered lots of existing mappings to support new/changing business requirements.
Used mapping variables, parameters, workflow variables & parameter files to support change data capture and automate workflow execution process, Migrated data from Netezza to Oracle.
Involved in writing UNIX shell scripts (Pre/Post Session commands) for the Sessions & wrote shell scripts to kickoff workflows, unscheduled workflows, get status of workflows.
Performed Informatica administration like user, privileges, migrations, starting, stopping pmrep/pm server. Backup and restore repository service.
Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL’s thorough out the projects
Supported Informatica, non-informatica code migration between environments (DEV/QA/PRD)
Developed Oracle PL/SQL Packages, Procedures, Functions and Database Triggers.
Performed unit testing, system integration testing, and supported user acceptance testing.
Environment: Informatica, Oracle, IBM DB2, Netezza, MS SQL Server, Flat files, SQL * Loader, Unix scripting, PL/SQL, Data Modeling, Data Analysis, Dimensional Modeling.
Education: Bachelor of Computer Science – Osmania university, Hyderabad India.