Developer Etl

GEETHIKA RAJANALA

561-***-**** ****************@*****.*** LinkedIn: GeethikaRajanala

Professional Summary

• Good knowledge with ETL tool Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center.

• Good experience working on ETL Customizations and scheduling ETL using Data warehouse.

• Good knowledge of XML mappings, XSD schema definitions and xml sources and targets.

• Good knowledge in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.

• Experience in documenting the necessary steps for migration of the Informatica code between different environments and using Informatica repository labels and deployment groups to complete/rollback the deployments.

• Strong knowledge of and experience with reporting packages (Business Objects etc.), databases (SQL etc.), programming (XML, JavaScript, or ETL frameworks).

• Knowledge of statistics and experience using statistical packages for analyzing datasets.

• Actively involved in the Maintenance of application, server management, various phases of Application Development, Implementation.

• Good Knowledge of Object-Oriented Development concepts.

• Experience in using RDBMS, Oracle, MySQL.

• Involved in creating reports/documents in Power BI and runbooks.

• Hands-on experience on development tools like Eclipse.

• Strong Excel skills: formula creation, pivot tables, graphing/charts.

• Experience in scripting and automation using Python, UNIX Shell & Windows Batch Scripting.

• Involved in UNIX shell scripting, FTP and file management in various UNIX environments.

• AWS Associate‘s certified.

• Proactive attitude with excellent analytical, communication and interpersonal skills Quick learner, innovative thinker, smart worker and adaptive team play.

• Have excellent Analytical, Problem Solving and Communication skills and can adapt to all environments and cultures with ease. Skills

Data Warehousing Informatica Power Center, SQL

Dimensional Data Modeling Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling Business Intelligence MS Access Reports, Power BI, MS-EXCEL Data Bases Oracle, MS SQL Server

Tools Tidal, Putty, JIRA, Weka, AWS

Languages SQL, PL/SQL, HTML, XML, Unix Shell Scripting, J2SE, J2EE, JSON, JDBC Web/App. servers Apache Tomcat

Operating System Windows and Linux

Experience

ETL Developer

• Worked with business teams to gather the functional requirements and translated them into ETL technical documents

• Trained in Various ETL strategies.

•Identified bugs in existing mappings by analyzing the pipeline data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.

• Used transformations lookup, Normalizer, aggregator, router, filter, expression, java, input, output, sequence generator and external procedure.

• Created Mapplets, and reusable transformations to implement the business logic.

• Extensively worked on performance tuning and monitoring of programs, ETL procedures and processes.

• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.

• Optimizing/Tuning mappings/sessions, indexing and partitioning for better performance and efficiency.

• Implemented Command Task, Control Task, decision task, event raise and event wait tasks within the workflows to stream line the session scheduling.

• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.

• Designed the parallel and sequential session workflows and scheduled the workflows and Sessions using the Workflow Manager.

• Wrote complex SQL scripts to avoid Informatica Look-ups to improve the performance as the volume of the data was heavy. American Consulting Solution, Boynton Beach FL ( September 2019 – Present ) ADT Security Services, Boca Raton FL ( May 2019 – August 2019 ) ETL Developer

•Understanding the data and conducting analysis for business requirements.

•Creates ETL Mappings, Mapplets, Workflows, Worklets, sessions using various transformations mapping such as joiner, union, look-up, router, etc. based on the requirements in Informatica PowerCenter 10x.

•Writing complex SQL queries using joiners, count, max, min, aggregate functions, etc. for optimization IN SQL developer and for informatica source definition.

•Understanding how the UNIX environment works in practical way. Parameterizing files for using in informatica, looking at file history to verify and validate if the files have been moved from source to target using putty.

•Unit testing to verify create mapping, workflow, session is valid by comparing the data loading from source to target in workflow manager.

•Use Tidal to schedule jobs, analyze job run times, calendar scheduled, etc.

•Create runbooks for EIM – Marketing Platform department with all the information like Workflows, mapping, vendors, Unix environment, SQL queries, Tidal Jobs, postproduction, etc. and update it into the Share point.

•Understand the working of Agile sprint, Complete assigned JIRA’s and update them in JIRA dashboard

•Attending Daily stand-up meetings to be aware of impediments, what JIRA’s are done or not- done and technical problems.

•Hands on experience in using PowerBI for business requirements for creating reports. Florida International University, Miami FL ( January 2019 - December 2019 ) Student Assistant

•Analyzes, designs, coordinates, and codes the development of software systems to form a basis for the solution of information processing problems using Java/HTML/CSS/JavaScript/SQL.

•Developed new application and added functionality to existing applications using Java/J2EE technologies.

•Writing SQL queries to retrieve data from the database using JDBC.

•Preparing reports for executive leadership that effectively communicate trends, patterns, and predictions using relevant data.

•Created and optimized Unix shell scripts to automate network administration tasks and application installation.

•Provided systems administration support for Unix and windows systems including server and workstation upgrades, backup and disaster recovery monitoring, user account setup and security administration, Performed regular system backups and recovery procedures.

•Worked on VMware administrator, managed virtual desktops and also resolved VMware related issues

•Worked on excel formula creation, pivot tables, graphing/charts. Secunderabad Public School, Hyderabad INDIA ( June 2017- june2018 ) ETL Developer

• Developed and tested extraction, transformation, and load (ETL) processes.

• Designed and developed Informatica's Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.

• Designed and implemented stored procedures, views and other application database code objects to aid complex mappings.

•Performs Unit Testing to ensure all code changes meet requirements / specifications.

• Maintained SQL scripts and complex queries for analysis and extraction.

•Develop SSRS reports and configure SSRS subscriptions per specifications.

•Gathered business requirements and converted it into SQL stored procedures for database specific projects.

• Debugged existing ETL processes and did performance tuning to fix bugs. Education

Florida International University, Miami, FL

Master’s in Information Technology with Security track

• GPA – 3.67

Jawaharlal Nehru Technological University, Hyderabad, India Bachelor’s in Computer Science & Engineering

• GPA – 3.47

Certifications

• AWS Certified Solutions Architect – Associate

• AWS Certified Developer – Associate

• AWS Certified SysOps Administrator – Associate

Contact this candidate