Vacancy expired!
DescriptionIT Concepts (ITC) is an 8(a) SDVOSB founded on the concepts of customer-centric, driven to deliver, teamwork, integrity, and innovation. Founded in 2003, ITC was established with a simple yet important promise to “deliver solutions that work”. As we continue to grow in the support of our government customers, we are looking for driven and innovative individuals to join our team.IT Concepts is looking for an experienced ETL Developer to support SSA - Social Security AdministrationPosition DescriptionBecome part of a team to help a large government agency support research and statistics efforts that help agency officials make recommendations on reforms. IT Concepts is seeking a ETL Developer.
- Design and develop Extract, Transform, & Load (ETL) processes to support MI/BI efforts
- Expertise in writing complex SQL queries in multiple environments such as Microsoft SQL Server / Greenplum/Oracle
- Expertise SQL Server Integration Services (SSIS) / SQL Server Analysis Services (SSAS)
- Experience in loading data from different sources / Building ETL pipe lines / implementing Enterprise Data Warehouses in SQL Server / Greenplum
- Designs and develops optimal code to maintain exceptional performance in processing large volumes of data.
- Good understanding of data distribution, table partitioning in SQL Server / Greenplum.
- Develops and implements an efficient migration process to move ETL objects from development to test and production environments.
- Understands database design, programming concepts, data modeling, and framework management.
- Exposure to SQL Server Database Administration (DBA) role
- Read, debug, modify, and create complex SQL code associated with a data warehouse.
- Translates business requirements into technical specification.
- Supports the project team throughout the design, development and testing process.
- Participates in all design reviews and requirement sessions, as required.
- Supports project documentation, as required.
- Communicates ideas to both technical and non-technical people in all levels of the organization.
- Works with Business Analysts, Data Architects, Enterprise Architects, and ETL Architects to ensure business requirements are being met with the solution being developed.
- Mentor other team members in developing, documenting and modifying ETL components.
- Work with versioning tools such as TFS and GIT
- Understand business and application requirements, develop and maintain software to support those requirements.
- Ability to work independently and multi-task effectively
- Extensive experience with Microsoft SQL Server and Greenplum
- Hands-on experience designing and developing ETL solutions involving large volumes of data for SQL Server / Greenplum
- Experience with large scale, complex data migration efforts.
- Hands-on experience designing data warehouses – Dimensions/Fact Tables
- Full comprehension of SQL, cardinality, levels of granularity, normalized vs de-normalized databases
- Expertise with – SQL Server Integration Services / SQL Server Analysis Services
- Expertise with gpfdist, PuTTY, File Transfer Protocols (FTP)
- Expertise PowerShell scripting
- Knowledge of SQL Server DBA activities
- Excellent oral and written communication skills are required.
- Excellent Analytical skills required.
- Flexibility/Adaptability is required, especially when working in a large team.
- Strong attention to detail and troubleshooting skills.
- Strong analytical and organizational skills. Excellent written and verbal communications skills.
- Ability to work well under pressure and demonstrate commitment to quality and client satisfaction.
- Be able to prioritize, multitask, meet deadlines, and coordinate schedules with others.