Developer Lead Resume Milwaukee, WI - Hire IT People

SUMMARY

Highly motivated and detail - oriented ETL Developer with 11 years of IT experience with primary skill set of Informatica, SQL and Shell scripting and working with varied Program and Organizations in the domains of Retail and Insurance and Banking.
Prime focus on Design, Development, Maintenance, and Enhancement of ETL applications.
Excellent hands on development, technical and team leadership, focused on timely delivery and quick return on investment (Using Waterfall/Agile/SAFe Framework.
Well accomplished in governance of Program using the Agile Ceremonies and working with a diverse variety of Distributed teams.

TECHNICAL SKILLS

Business Modeling Tools: MS Visio, HP ALM

Management Tools: MS Project professional, JIRA Align, TFS, HP-ALM, Wiki, SharePoint

Technologies/ Languages: SQL, Unix/Linux Shell Scripting, Macros

Project Methodology: Software Development Life Cycle (SDLC), Agile/Kanban/Scrum, SAFe and Waterfall, ATDD, TDD, DevOps

ETL Tools: Informatica Power Centre 6.2/7.1.3/ 8.1/9.1/9.5 , Power BI, Erwin

Database: DB2,SQl Server, Oracle 9i/10G

Other tools: Toad for Oracle 8.6, Control M, Clear case, CA Workload, Putty, Autosys, Gitbab/Github

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Developer Lead

Environment: Erwin, Informatica 9x/10x, DB2, Unix/Linux, PowerBI, Autosys

Responsibilities:

Instrumental in identifying/analyzing the sources create necessary documentation for the development teams; design the table structures, guide team with ETL solutions for field forces.
Maintained UNIX Shell scripts for data integration flow from outside sources to load into ETL for pre/post session operations and various day - to-day operations using Informatica power center.
Documenting and updating the deployment plan, test plans, design plans, production support plan etc.
Designated owner and accountable for major tasks and took responsibility for actions and outcomes to ensure timely and cost-effective results for our team.
Work with peers from various functional areas to define IT wide processes like code reviews, unit test documentation and knowledge sharing sessions.
Collaborate and work with business analysts and data analysts to support their data warehousing and data analysis needs.
Provide/update common business vocabulary and inventory of data structures using Common Data View, Core Data Model and Rochade.

Confidential

ETL Developer

Environment: Informatica 9.1.0, SQL Server 2008, Oracle 9i, UNIX, Clearcase, CA workload, Putty

Responsibilities:

Develop and deploy integrated solutions aimed at modernizing, consolidating and coordinating vendor and independently designed applications across the enterprise to meet business needs.
Accountable for assessing the impact of change on application/systems to support and maintain performance, availability and data accuracy.
Convert High level architectural design to a detailed application design; may include software product evaluation and buy vs build recommendations also includes efficient reuse of existing components.
Tuning the Informatica mappings and SQL's for optimal load performance Involved in the production support, watch the workflow monitor carefully to see all workflows and all Tasks are running properly and data is loading in the proper way and to the right targets and at the right time.
Handling daily status and issue call with client along with Team.
Worked extensively to support the 24x7 application by putting in data quality checks, day over day validations to ensure data completeness and integrity.
Designated owner and accountable for major tasks and took responsibility for actions and outcomes to ensure timely and cost - effective results for our team.

Confidential

Sr. Software Developer

Environment: Informatica 9.1.0, DB2, UNIX, Control -M

Responsibilities:

Gather information and business requirements from clients through regular meetings and verify the requirements completely and these requirements are reviewed and formally approved.
Designing and developing ETL mappings keeping in view of performance criteria.
Involved in testing and Informatica mappings with manual testing and assigned QA team and used SQL tools like TOAD to run SQL queries and validate the data loaded into tareget tables.
Used Informatica Workflow Manager & Monitor to Create, Schedule, Monitor workflows.
Finding the errors when session fails and rectifying the same ASAP.
Working with data and ETL architects to helps design an optimal solution.
Perform root - cause analysis of identified issues that arise post-implementation and work on solution related to issues.
Accountable for assessing the impact of changes on applications/systems to support and maintain performance, availability and data accuracy.