Home

Sasanka - ETL / Informatica Developer

[email protected]

Location: Frisco, Texas, USA

Relocation: Yes he can relocate

Visa: H1B

PROFESSIONAL SUMMARY: Over 10+ years of work experience in Information Technology as an Informatica Developer with strong background in ETL Data warehousing experienced using Informatica PowerCenter. Experience in software development life cycle (SDLC), business requirement analysis, design, programming, database design, data warehousing and business intelligence concepts, Star Schema and Snowflake Schema methodologies. Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server and Mainframe applications. Expertise in design and implementation of Slowly Changing Dimensions SCD type1, type2, type3. Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc. Experience in using Informatica Power Center tools Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager, metadata Manager. Experience in using Python coding for monthly report creation. Experience in Dimension Data Modeling concepts like Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling. Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica PowerCenter tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Informatica Administration Console). Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases. Experienced in loading data, troubleshooting, debugging mappings, performance tuning of Informatica Sources, Targets, Mappings and Sessions and fine-tuned transformations to make them more efficient in terms of session performance. developing ETL solutions on AWS, including using AWS Glue, AWS Data Pipeline, and AWS Step Functions. It also indicates my proficiency in programming languages like Python and SQL, which are essential for developing ETL workflows. Experience in ETL using Informatica PowerCenter9.6.1 from sources like Oracle, and Mainframes Cobol Flat files Experience in developing complex SQL queries and Implementing Production Data fixes using SPUFI, QMF tool in IBM DB2 Experience working in Development/Maintenance/Sub-Production Batch support of Mainframes applications Design, Development, Testing, and Implementation of ETL processes using Informatica Cloud Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases. Strong experience in working with large scale Data Warehouse implementations using Informatica PowerCenter 8.x/7.x/6.x, Oracle, DB2, SQL Server on UNIX and Windows platforms. Excellent interpersonal and communication skills, and is experienced in working with senior level managers, businesspeople, and developers across multiple disciplines Developed reports to visually explore data and create an interactive report Tableau and Power BI. Used UNIX shell scripts for automating tasks for BTEQ and other utilities. TECHNICAL SKILLS: Operating Systems Windows, UNIX, MS-DOS ETL Tools Informatica Power Center 10.x,9.x,8.x (Designer, Workflow Manager, Workflow Monitor, Repository manager, Workflow Designer and Informatica Services), Informatica Power Exchange, informatica MDM 9.5, IDE 9.5.1,IDQ 9.6.1/9.5.1, Informatica Intelligent Cloud Services (IICS), IBM Mainframes Databases Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata, Vertica, Cloud (Palantir) Big Data Technologies Apache Hadoop, Spark Data Modeling tools Erwin, MS Visio BI Reporting Tools Cognos, Tableau, Power BI and Looker Languages SQL, PL/SQL, UNIX Shell scripts, C++, Python Cloud AWS Scheduling Tools Autosys, Control-M, TWS (Tivoli Work Scheduler) ________________________________________________________________ Thanks and regards, Sai Kiran Sr Bench Sales Recruiter, Cloud Info Inc. Direct : 302-206-7225 EXT:107 | Email : [email protected] LinkedIn : https://www.linkedin.com/in/kiran-rasuri-8009ba190/ Keywords: cplusplus business intelligence information technology microsoft procedural language