Careers that Change Lives
The resource will perform ETL Development work for the Business Intelligence group of Global Applications.The resource will develop code supporting execution of the design provided by the DA.The resource will participate in code reviews, execute unit testing, support UAT and document and monitor implementations.The resource will also provide trouble shooting expertise to assigned Production issues, and interface with the Team in MN.
A Day in the Life
Specific Technical Knowledge Required :
- Utilize ETL tools (Informatica) in support of development based on business model design and source data.
- Utilize shell scripting protocols for effective delivery of assignments
- Code development, unit testing and deployment to production.
- Collaborate proactively with functional users, analysts and other team members to solidify deliverables.
- Understand business requirements, determine implementation strategy and translate into code that conforms to best practices and standards.
- Troubleshoot and resolve technical issues. Debug, tune and optimize code for optimal performance.
- Schedule jobs via the Tivoli utility.
- Understands security requirements for data access
- Provides direction to subordinates based on general policies and management guidance.
- Perform work reviews upon completion of assignments to ensure adequacy in meeting objectives
- Interprets and ensures compliance to policies and procedures and recommends enhancements that impact the Business Intelligence group.
- Adherence to best practice guidelines, meets all business requirements and delivers projects on schedule and on budget
- Good understanding of the entire project life cycle.
Must Have : Minimum Requirements Required Skill Sets Bachelors or higher level degreeYears of Experience -7+ ofETL DevelopmentETL Skills -Proficiency in Informatica v 9.6 and aboveSQL & PL / SQL -Good Knowledge of PL / SQL CodingPython -Good Knowledge of Python CodingWritten / Oral Communication Skills -Excellent
Desired skills :
Familiarity with SAP HANA.Familiarity with Oracle ExaData.ETL experience, Informatica proficiency v 9.6 and aboveExperience with DBTNice to Have
Organizational :
Works effectively and independently in a dynamic environment.Responsible, takes ownership of work, and follows through to completion.Possess high attention to detail traits.Ability to multi-task and follow processes.Ability and desire to perform "admin" work as well as "technical" work.Experience working with demanding deadlines, high workload and some degree of conflicting priorities.Self-motivated, self-managed, and results-oriented with a strong work ethic, excellent organizational skills and perseverance to accomplish objectives.Analytical :
Excellent diagnostic, problem solving and issue resolution ability.Able to learn quickly with minimal supervision.Ability to determine the clients' true business needs.Ability to assess status quo, and come up with new ideas.