Hi, Hope you are doing great!!
*Role: Informatica Developer* *Location : Madison, WI* *Duration : 6 Months + * *Insurance Domain Preferred*. *JOB DESCIPTION* *Job Purpose* Under the direction of Information Technology Management, this position will be responsible for designing ETL components related to projects and/or functional enhancements. This person will provide technical leadership which include, designing and data modeling the most efficient ETL solutions, partnering with other IT Architecture roles to define those solutions, and articulating those solutions to the development staff for delivery. An important role this person needs to play is the ability to understand the scope of a project, create long term, solid, ETL solutions, while keeping in mind the bigger picture. 1. Collaborate with Information Technology Architects to understand information, data, and technology standards. Ensure alignment of enterprise standards with internal ETL architecture and designs. 2. Ability to perform Data Modeling (Dimensional/Operational) within Erwin, assist with defining standards and assure adherence to standards. 3. Continuously evolve understanding of where the overall enterprise data strategy is going. 4. Create/Evolve internal teams ETL architecture and designs standards by partnering with other peer ETL designers 5. Design enterprise reusable ETL components to improve design & coding efficiencies. 6. Define/Create ETL design solutions which would include supporting artifacts and design deliverables depending on technology. Define ETL flows, transformation rules and framework to support ETL development. 7. Ability to lead a team of developers to drive to a solution. 8. Lead advanced troubleshooting and problem resolution functions for ETL/Data issues. 9. Make recommendations on increasing scalability and robustness of ETL platforms and solutions. 10. Mentor/Coach less experienced staff. 11. Ability to provide level of effort estimate for the entire ETL strategy as it pertains to a given project. 12. Accountable for the overall delivery and success designed solutions. 13. Collaborate with others across the IT organization to understand all aspects of the project with the goal to drive a collective robust solution. 14. Build collaborative relationships with business customers to understand their goals, needs, and objectives and use as input to the overall ETL architecture and design. 15. Ability to articulate complex solutions in an easy to understand fashion. 16. Ability to articulate all needed activities to assigned project manager/leader on any given project and track actual work back to given estimates. *Job Responsibilities* 75% - Data Model, Design and Architect ETL BIDW internal solutions which would include standard delivery artifacts based on technology. Partner with Information Technology Architects and others across the organization to create a solid, long term supportable solution. Lead a team of developers to execute and drive designed solution towards completion on time and within budget. Continuous communication back to assigned leaders on status and progress of teams activities. Ability to lead and drive work activities that have interdependencies with other teams and drive resolution on any of issues related to your work activity. Overall accountability for ensuring the successful delivery of designed solution, small or large. 15% - Provide level of effort estimates for any work activities as it relates to functional enhancements or projects. Continue to build system knowledge not just within our team but across the organization with the goal of building a better understanding on how data assets should be designed and architected. Continuous partnership with the Enterprise Architecture team to understand the strategy, future technical direction, and enterprise tool standards our team should leverage. Continued partnership with business to understand their requirements and translate those into long term supportable solutions. Continue to understand Data Office to understand their future vision to incorporate into built solutions. 10% - Focus on continuous education, process and architectural improvements as it relates to day to day activity or when designing solutions. Continue education on new technologies or existing technologies with the goal of looking for streamline opportunities. *Required Skills* · Bachelor’s degree in Computer Science, Mathematics, Information Systems, or Data are preferred or equivalent work experience. · 8+ years progressive experience in architecture/ system design/data analysis related to ETL, data management, data integration and data delivery work. · 8+ ETL experience using one or more of the following tools/database platforms o Informatica Power Center version 9.6 or higher o SSIS SQL Server Integration Services o Microsoft Azure stack (Hive/Pig/Hadoop/Python) o Microsoft SQL Server 2008 or higher · Architect/design ETL solutions to process/load source systems data into multiple database · 3+ years hands on experience with dimensional and operational data modeling · 5+ years hands on lead experience architecting and designing ETL components · Strong skills with understanding the tradeoffs of various design options on multiple platforms · Experience with preparing technical artifacts to support design efforts · Ensures adherence to design/development standards · Ability to Lead a team of technical people which would include on/offshore vendor partners · Good communicator and proactive approach to daily activities · Positive and problem solving attitude · Experience in Agile technical project data delivery · Ability to build collaborative relationships across the organization · Ability to plan, orchestrate, and coordinate technical release activities · Very strong analytical complex thinking · Ability to communicate back to non-technical stakeholders in a easy to understand manor Regards *Ajit Rathore* *InfiCare **Technologies*| 22375 Broderick Drive #225 Dulles VA 20166 | 703-945-1834 Direct | *aj...@inficaretech.com* <aj...@inficaretech.com> *www.infiCareTech.com* <http://www.inficaretech.com/> Servicing our clients since 2001 MBE/ DBE Certified in VA, MD, PA, NJ, NC, CA IT Services * Application Development * Mobility Solutions -- -- *************************************************************************************** For all SAP related tutorials,Articles,Faqs,Tips www.sapbrainsonline.com **************************************************************************************** You received this message because you are subscribed to the Google Groups "sapbrains" group. To post to this group, send email to sapbrains@googlegroups.com To unsubscribe from this group, send email to sapbrains-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sapbrains?hl=en --- You received this message because you are subscribed to the Google Groups "sapbrains" group. To unsubscribe from this group and stop receiving emails from it, send an email to sapbrains+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.