As part of the Business Intelligence team, the ETL Developer III plays a key role in designing, developing and supporting new and existing ETL framework solutions. The framework developer's primary contribution to the team involves developing common and reusable components that be used by cross-functional delivery teams. Projects are usually of considerable complexity and require a mastery of development tools. Performs maintenance and provides technical assistance and advice on existing software solutions.
MAJORDUTIES AND RESPONSIBILITIES
Work closely with the IT team and Architecture team members to achieve business objectives.
Design, develop, implement, and support new and existing data integration software using UNIX, Teradata, and Hadoop.
Influences system design by identifying and recommending design and requirements needs for software enhancements
Leads code review sessions to validate adherence with development standards. Reviews and provides input into development standards.
Maximizes the efficiency of the various software systems by implementing, monitoring, testing and auditing new software programs
Participates in continuous performance improvement sessions to discuss opportunities to improve processes or standards
Follows established configuration/change control processes
Develop technical documentation to support production deployments as well as ongoing maintenance of existing framework and data solutions
Troubleshoot, diagnose and resolve data quality and performance issues
Communicate complex topics and analyses to non-technical business personnel.
Provide accurate level of effort estimates for data integration development to management.
Actively and consistently supports all efforts to simplify and enhance the customer experience
Perform other duties as requested by supervisor
Skills/Abilities and Knowledge
Ability to communicate orally and in writing in a clear and straightforward manner
Ability to communicate with all levels of management and company personnel
Ability to handle multiple projects and tasks
Ability to make decisions and solve problems while working under pressure
Ability to prioritize and organize effectively
Ability to show judgment and initiative and to accomplish job duties
Solid understanding of Microsoft Office Suite (Word, Excel, Visio, MS Project, etc.)
Ability to work with others to resolve problems, handle requests or situations
Ability to perform detailed business analysis and design
Ability to transform business requirements into a technical solution.
Knowledge of different ETL design and development methodologies.
Strong knowledge of SQL and Stored Procedures
Strong understanding of BI/DW architecture and concepts
Strong understanding of how data governance plays a role in BI.
Strong understanding of how multiple data sources can be consolidated together to produce BI Solutions.
Bachelor's degree or foreign equivalent in Information Technology or business related field, or equivalent experience
RELATED WORK EXPERIENCE
7+ years of SQL Query Design in large-scale data warehouse environments
7+ years of data integration development using ELT methodology
7+ years of data collection and database/report design
7+ years of work experience in delivering IT/BI solutions
5+ years of UNIX shells scripting
2 + years of experience working with Teradata database & Utilities
2+ year of Python experience
2+ Years of Hadoop experience
Experience working with Telecom/Cable MSO data and applications
Certification on Teradata and/or MicroStrategy, Tableau is a plus
Experience working with Teradata utilities like TPT, FastLoad, Multi Load, Tpump, Teradata stored procedures
Experience with various relational databases like Oracle, Mysql, Microsoft SQL, and Teradata
Experience in Big Data related technologies like Hive, PIG, PySpark, Spark, Hbase etc.
Experience working with AWS or other cloud platform big data tools such as Elastic Map Reduce (EMR), S3, Redshift, snowflake.
Experience working with bash scripting and the AWS CLI in Linux-based systems
Advanced data souring mechanism including CDC (IBM IDR) and Kafka
Experience working with ETL workflow and scheduling applications
Experience on version control tools like SVN and Git/Bit bucket
Knowledge on JIRA ticketing system
Familiarity with Agile development methodologies such as Scrum, Kanban and SAFe
Posting ID: 574644920Posted: 2020-09-30