Tampa
Job Description Who we are! At 4Ci our mission is to build long term relationships, based on trust, integrity, and knowledge with all our employees and business affiliates. 4Ci has been in business for 20 years and has employees working on mission critical projects nationwide. We provide computer programming, testing, and system design services to develop and maintain multi-year, multi-million-dollar mission critical applications for the US Government. Examples of such applications are Medicaid MMIS systems, Health Insurance Exchange, Child Support, Food Stamps, and Unemployment Insurance. We hire people that have desire, aptitude, and attitude to work with our clients such as big 3 consulting firms and US State Government and others. While employed with us you get hands on experience with very large-scale mission critical applications that use latest in technology trends and software tools. We invest in training our resources and retool their expertise to meet our project needs. More importantly our employees have a well-defined social and business purpose to help our clients deliver social and welfare benefits to millions of needs families by use of technology and knowledge. What we do We partner with big 3 consulting firms to design, develop, and maintain complex, heterogeneous, and client facing web-based automation systems that deliver social and welfare benefits to millions of families, nationwide. To develop such highly complex web applications we need professionals with broad range of experience and skills ranging from subject matter experts, computer programmers, project managers, tester, systems analysts and others. We invest in training our employees and retool their expertise to meet our project needs. Role Title: ETL Developer Duration: 6 Months Location: Tampa, FL Job Description: · 6 - 12 years of Hands-on experience in Ab Initio (v4.0 and above) ETL Projects, Ab Initio solution design and documentation. Ab initio experience including GDE, Plans, continuous flow, m-hub and ACE/BRE. · Good experience in end-to-end implementation of DW BI projects, especially in data warehouse and mart developments involving multiple teams · Strong knowledge and hands-on experience in PL/SQL, Unix shell scripting · Knowledge and experience with the full SDLC lifecycle · Experience with Lean / Agile development methodologies · Should have Ab Initio development in GDE experience with an Understanding of GDE components like reformat, normalize, rollup, scan, sort, partitioning and de-partitioning components, integration of java workflows with ab initio · Should have strong understanding of Ab Initio graph subgraph, psets, plans ad air command, m-commands concepts · Should have Developed custom graphs implementing complex business requirements using GDE · Preferably should have worked on latest version of Ab Initio and BRE · Experience working on continuous flow graphs, Messaging queues. · Support ongoing ETL efforts in multi-lane Development, SIT, UAT and Production Environments. · Research new solutions, tools and methodologies that may improve the overall operation model process · Work very closely with business analysts, development teams and project managers for requirements and business rules. · Full life cycle Data Warehouse experience including star schema and dimensional data · Strong understanding of relational databases such as SQL server, Oracle Teradata. · Experience with writing complex SQL for data analysis and data profiling. Job Responsibilities: · Experienced in architecture and technical design and development of ETL, data & transformation programs and in delivering enterprise-complexity ETL solutions using Ab-initio suite using products such as: GDE, Co-Operating System, Control Center, BRE, Express It, Continuous Flows, Metadata Hub, Test Automation · Analyses requirements and design documents, and creates technical mapping documents, data models, and transformation rules and validates with client teams · Develops Ab initio components (frameworks, graphs) based on agreed-upon detailed functional and technical documents · Configures Ab initio components and performs unit testing · Experienced in Unix, RDBMS and SQL · Create well-informed and approved architecture and standards to addresses data integrity, performance, scalability, continuity of business and high-availability · Collaborate with client teams to finalize architecture components including designing, creating artifacts, and submitting for architecture review and approval · Maintain and improve architectural design and components for applications and projects using Ab initio · Supports client architects with analysis, designs, planning and management of effort to evaluate effort and quality targets Job may require travel to unanticipated client sites with expenses paid by the employer. 40 hours per week. M-F. Must be authorized to work in the United States. Email resumes HR, 4Consulting, Inc., 6850 TPC Drive Suite 208 McKinney, TX 75070. Disclaimer 4 Consulting Inc. offers a comprehensive compensation and benefits package. 4Ci is an affirmative action-equal opportunity employer. 4Ci complies with all applicable federal, state and local laws regarding recruitment and hiring. All qualified candidates are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other category protected by applicable federal, state or local laws. Company DescriptionAt 4Ci our mission is to build long term relationships, based on trust and integrity, with all our employees and business affiliates. We partner with world’s largest corporations to design, develop, and maintain complex, heterogenous, and client facing web-based automation systems that deliver social and welfare benefits to millions of families.At 4Ci our mission is to build long term relationships, based on trust and integrity, with all our employees and business affiliates. We partner with world’s largest corporations to design, develop, and maintain complex, heterogenous, and client facing web-based automation systems that deliver social and welfare benefits to millions of families.