Data Integration Developer-Rolling Meadows IL - Georgia IT Inc.
Rolling Meadows, IL
About the Job
Data Integration Developer
Location: Rolling Meadows IL
Contract
Rate: DOE
US Citizen, GC Holder and EAD
Education and Experience »
- Bachelor's degree
- 5 years related experience
- BI development leveraging the Microsoft SQLServer or PDW/ASP data environments experience a plus
- Experience with SSIS and use of Stored Procedures a plus
- Experience with Azure Data Ware house, Azure Data Factory, SQL VMs a plus
- Experience guiding/mentoring developers with lesser experience
- Experience with business intelligence and data warehousing design principles and industry best practices a plus
- Strong communications skills - oral and written
- Self-starter with strong work ethic
- Ability to handle multiple tasks and projects simultaneously.
- Problem solver and desire to close issues, pragmatic and realistic with solutions
- Strong sense of accountability, adaptability, flexibility and a sense of urgency
- Ability to establish priorities, organize and plan work to satisfy established time frames
- Directs, prepares, designs, codes, tests, debugs, and maintains complex computer programs
- Under general direction, formulates and defines system scope and objectives
- Works with users to support business applications, and investigate operational problems/system requirements
- Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results
- Prepares detailed specifications from which programs will be written
- Designs, codes, tests, debugs, and documents those programs
- May be responsible for completion of a phase of a project
- Solves user inquiries that arise during day-to-day operation
- Regularly provides coaching, guidance and training to less-experienced analysts/programmers
- Collaborate with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems
- Identifies data sources, provides data flow diagrams and documents source to target mapping and process
- Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports
- Facilitate the development of data integration efforts by leading small teams of 1-2 junior developers in addition to hands on design and development of large complex ETL jobs
- Design, implement and maintain database objects (tables, views, indexes, etc.) and database security
- Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware
- Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
- Establish methods and procedures for tracking data quality, completeness, redundancy and improvement
- Work with the Data Architect to establish processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments
- Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques
Source : Georgia IT Inc.